Creating MSSQL Users for SmartPTT

Prerequisites

• Start SQL Server Management Studio (SSMS) on the MSSQL host.

Process

1. In the SSMS, access the Object Explorer panel.

   

2. Connect to the requires MSSQL server.

   How to...

   1. In the panel, from the Connect list, select Database Engine.
      Server connection settings appear.

      

   2. In the window that appears, in the Server name field, enter localhost\<server name>.

   3. From the Authentication list, select Windows Authentication.
   4. Click Connect.

3. In the Object Explorer panel, expand <hostname>\<MSSQL instance name> → Security.
   Security-related settings appear.

   

4. Right click Logins, and from the action menu, select New Login.
   Login settings appear.

   

5. Set up a new account:

   1. In the window that appears, click the General tab.
   2. On the tab, in the right pane, in the Login name field, enter user login.
   3. Click SQL Server authentication.
   4. In the Password field, enter user password.
   5. In the Confirm password field, enter user password again.
6. Modify password policies:
   1. Clear the Enforce Password Expiration check box to authentication account self-disablement.
   2. Clear the User must change password at next logon check box to ensure ability to authenticate.

7. Set up necessary permissions:

   1. In the left pane, select the Server Roles tab.
      List of roles appears.

      

   2. In the view that appears, select the sysadmin check box.

8. Set up user status:

   1. In the left pane, select the Status tab.
      Account statuses appear.

      

   2. In the right pane, in the Permission to connect to database engine area, click Grant.

   3. In the Login area, click Enabled.

9. In the Login - New window, click ОК to create the user account and close the window.

10. On the Object Explorer panel, right click <hostname>\<MSSQL instance name>, and from the action menu, select Restart.