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.
This post first appeared on Oracle ADF, BPM, BI And Primavera P6 Tutorials, please read the originial post: here