Configuring the SQL databases

1. Open SQL Management Studio.
   

   

2. Change the Connection Security option from 'Mandatory' to 'Optional' in the drop-down.
   

   

3. Login with the default Windows Authentication by selecting Connect.

4. Right-click on the root of the Object Explorer tree and select Properties.

   

5. In the Server Properties window, select Security.

6. Change the Server authentication to (Mixed Mode): SQL Server and Windows Authentication mode. This information can also be set during the SQL installation if it hasn’t already been configured.

7. Select OK.

   

8. In the Object Explorer tree, expand the Security and Logins folders.

9. Right click on the 'sa' Login and select Properties.

   

10. In the Login Properties window select the General page.

11. Enter a new password into the Password and Confirm password spaces.

    This password needs to be entered later during the installation of T4D, therefore it is important to note the default or changed password for future reference.

    

12. In the same Login Properties window select the Status page.

13. Ensure that the Settings are set to:

    • Permission to connect to database engine Grant

    • Login Enabled

    

14. Select OK.

15. Refresh (blue circular arrow) the Object Explorer window to see the 'sa' Login become active.

    The 'sa' user name and the password (set in Step 11) will be needed later on during the installation.

    

     

16. The server must now be restarted to ensure that all changes are applied to the SQL database. Please perform a server restart before continuing to the next section.