Step 1

Enable SQL server and Windows authentication:

1. In the left navigation pane, right-click the name of the Microsoft SQL Server, then click properties.

2. Click Enable SQL Server and Windows Authentication mode.

Step 2

In the left navigation pane, right-click Databases and click New Database.

Step 3

Enter an appropriate name in the Database name field.

Step 4

Click OK. The new name appears in the left navigation pane nested under databases.

Step 1

Log in to the Microsoft server where SQL Server is installed.

Step 2

Select Start > Microsoft SQL Server > SQL Server Configuration.

Step 3

In the SQL Server Configuration Manager, select SQL Server Network Configuration > Protocols for <named_Instance_name>, and then select the TCP\IP protocol name.

Step 4

In the TCP\IP properties for the named instance, select the IP Address tab. The configuration will have several IP configuration sections, such as IP1, IP2, IP3, IP4, IP5, IP6 and IPALL.

Step 5

Perform the following steps for each of the above referenced IP configuration sections:

1. Remove any configuration in the <TCP Dynamic Ports> field.

2. Choose a TCP port you want to use for the named instance and update the TCP Port field with the chosen port.

3. Add a firewall rule for the SQL named instance.

Step 1

In the left navigation pane, right-click Security > Login and click New Login.

Step 2

Enter an appropriate name in the Login name field.

Step 3

Check the SQL Server authentication check box.

Step 4

Enter a new password in the Password field and confirm the password in the Confirm password field.

Step 5

Check the Enforce password policy check box.

Step 6

Choose the database you want to apply this new user to from the Default database drop-down list.

Step 7

In the left navigation pane of the Login - New window, click User Mapping.

Step 8

Under the Users mapped to this login list, check the database to which you want to add this user.

Step 9

Click User Mapping, in the Map column of the Users mapped to this pane pane, check the check box of the database you have already created.

Step 10

In Server Roles, ensure that only the public role check box is checked.

Step 11

Click OK. In Security > Logins, the new user is created.

Step 1

In the left navigation pane click Databases, then click on the name of the database that you have created and click Security > Users.

Step 2

Right-click on the name of the database user to who you want to add owner privileges, then click Properties.

Step 3

In the Database User pane, click Membership.

Step 4

In the Role Members list, check the db_owner check box.

Step 5

Click OK.

Step 1

Create a new database role for executing stored procedures:

1. In the left navigation pane click Databases, then click the name of the database to which you want to add new database roles.

2. Right-click Roles, and click New Database Role.

3. In the Database Role window, click General.

4. Enter an appropriate name in the Role name field.

5. Click Securables, then click Search to open the Add Objects window.

6. Choose the Specific Objects radio button, and click OK.

7. Click Object Types to open the Select Object Types window.

8. In the Select Object Types window, check the Stored procedures check box and click OK. Stored procedures is then added to the Select these object types pane.

9. Click Browse.

10. In the Browse for Objects window, check the following check boxes:

    • [dbo][jabber_store_presence]

    • [dbo][ud_register]

    • [dbo][ps_get_affiliation]

    • [dbo][tc_add_message_clear_old]

    • [dbo][wlc_waitlist_update]

11. Click OK. The new names appear in the Enter the object names to select pane.

12. On the Select Objects window, click OK.

13. From the Database Role window, click the first entry in the list of objects in the Securables list.

14. In the Explicit list, check the Grant check box for the Execute permission.

15. Repeat step 13 and 14 for all objects in the Securables list.

16. Click OK.

    A new database role is created in Security > Roles > Database Roles.

Step 2

To update the database user's database role membership:

1. Under Security > Users, right-click on the database user you have created, then click Properties.

2. In the Database User window, click Membership in the left navigation pane.

3. In the Role Members pane, uncheck the db_owner check box.

4. Check the check boxes for db_datareader, db_datawriter, and the database role which you created in step 1.

Step 3

Click OK.

Step 1

From the SQL Server Configuration Manager, click SQL Server Network Configuration > Protocols > TCP/IP in the Console.

Step 2

In the TCP/IP Properties dialog box, on the IP Addresses tab, right-click on the IP address that you want to configure and then click Properties.

Step 3

Check the TCP Dynamic Ports dialog box, if it contains the value 0, delete the 0. This prevents the Database Engine from listening on dynamic ports.

Step 4

In the IPn Properties pane, type the port number you want this IP address to listen on in the TCP Port pane.

Step 5

Click OK.

Step 6

Click SQL Server Services in the Console pane.

Step 7

In the Details pane, right-click SQL Server (instance name) and then click Restart, to stop and restart the Microsoft SQL Server.