Microsoft SQL Server
Microsoft SQL Server |
|
|
This section covers the procedure to create and configure the database in the SQL Server. See the steps below:
1.Open SQL Server Management Studio.
2.Connect to the server.
3.Right-click on Databases and then click on New Database.
4.On the left side, on the General page, enter a name in Database name. Example: sesuite
5.On the left side of the Options page, choose the 'collation' to be used and click on OK.
6.In the hierarchical tree, expand the Security item.
7.Right-click on the Logins button.
8.Click on New Login.
9.On the left side of the General page, in the Login name, enter a name for the login. Example: sesuite
10. Check the SQL Server authentication option.
11. In Password, enter a password and confirm it in Confirm password.
12. Uncheck the Enforce password policy option.
13. In Default database, select the database created in steps 3 to 5.
14. In Default language, select the English language.
15. Click on the User Mapping page and, in Users mapped to this login, select a database created from steps 3 to 5.
16. In the Database Role membership box, check the following options: ▪Public; ▪db_owner.
17. Click on OK;
18.Run the following commands to apply a property that the application uses, replacing <Database> with the name of the created database:
Network configurationIt is necessary to enable the TCP/IP connections in SQL Server Configuration Manager. See the steps below:
19. Open the SQL Server Configuration Manager;
20. In the hierarchical tree, expand the SQL Server <version> Network Configuration item.
21. Click on Protocols for MSSQLSERVER.
22. In the box on the right side, right-click on TCP/IP.
23. Click on Properties.
24. On the Protocol tab, in Enable, select the Yes value.
25.Access the IP Addresses tab.
26. In each existing IP, in Enable, select the Yes value.
27. In each existing IP, check whether the port defined in TCP Port is 1433.
28. Click on OK and restart the SQL Server.
|