Run Site Manager.
Go to the Results DataSource tab and enter the required information.
The Results database object may not exist at this point if this is a brand new installation (Test Connection will FAIL - this is ok). The information still needs to be entered here since it will be used by Results Database Utility to create the database object when the tool is run.
Server Name - Enter the name of the database server. If using a named instance include the instance name with the server.
Database Name - Enter the name of the Results Database.
Windows Authentication - Select one of the two available methods of authentication for connecting to the databases:
Windows Authentication - Set the dropdown to 'True'.
SQL Authentication - Set the dropdown to 'False'.
DataBase UserName - Enter the user name of the SQL user login; must have the 'dbowner' privilege level in SSMS. This is the login used by Results Database Utility to create/modify the Results database in SQL Server.
Password - Enter the password for the SQL user.
Confirm Password - Re-enter the SQL user password.
Click Save.
Can we improve this topic?