8 total views, 0 views today

How to create a database in Microsoft Sql Server 2017 Developer Edition – Part 2

This is the continuation of my previous post ‘MS SQL Server 2017‘. This section we explained how to create a database in MS SQL Server.

Create a Database in MS SQL Server

1. Go to Windows Start Menu >> Under M >> Select SQL Server 2017 Master Data Services Configuration Manager

2. The Master Data Services Configuration Manager opens on the screen. Click on the Database Configuration >> and Select Create Database

2. The Create Database wizard appears on the screen >> Click Next on the screen

3. Input the hostname >> Choose the Authentication Type >> Input the credentials if you selected SQL Server Account like me >> Test the connection

Note: I specified the password in MS SQL Server installation. Please refer the Step 15 of MS SQL Server Installation for SA password reference

4. Input a database name and select Next

5. Input the Windows user account which you grant Administrator access to this database >> Click Next

6. Click Next

7. Once the database successfully created >> Click Finish

8. You will see the MS SQL Server instance like below .

9. You will see the list of MS SQL Server instance running in the Windows Services

That’s it. The below steps are optional. They are required only you want to enable MDS on MS SQL Server

Configuring Master Data Services Server Configuration in MS SQL Server

9. Click on your Host name (Here: Gayathri-HP) and verify all the IIS components are installed. For me, some of the IIS components are missed as like below , so I going install those in the next steps

Open the Turn Window Features On or Off

Toggle On the following IIS components required for the Microsoft SQL Server and Click Ok

Restart the machine and check again. You will see the Master Data Services Server Configuration like below

10. Click on the Web Configuration >> Select the Website from IIS Server >> Click create >> Input an Alias Name >> Input the Window Credentials >> Click Ok

11. You will notice the alias as the arrow mentioned >> Now click on the button Select under Associate Application with
Database server details >> Click Connect >> Click Ok

12. You will notice the selected instance as the arrow mark mentioned >> Click on the Apply button

13. Open File Explorer and Copy the following packages from Samples to Configuration directory as shown below

10. Open a command prompt as administrator and run the following commands

Cd C:\Program Files\Microsoft SQL Server\140\Master Data Services\Configuration

MDSModelDeploy deploynew -package chartofaccounts_en.pkg -model ChartofAccounts -service MDS1

MDSModelDeploy deploynew -package customer_en.pkg -model Customer -service MDS1

MDSModelDeploy deploynew -package product_en.pkg -model Product -service MDS1

11. Launch the IIS MDS web by going to the http://gayathri-hp/MDS1/home/gettingstarted

That’s it. In my next post, I will explain how to install MS SQL Service studio so that we can access the SQL Server instance and query against it.