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 DbMigrator 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 DbMigrator 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?