Page History

...

1. In Host/Instance Name, specify the host SQL Server instance you want to use for the IDERA SQL Query Tuner Repository database.

2. Optional. Type a port to use for your SQL Server instance if it is not the default port.

3. Choose the appropriate connection protocol.

4. If you do not want to use the default name for the IDERA SQL Query Tuner Repository database, type the appropriate name. If your SQL Server environment uses SSL to connect, check Use Encryption.

5. If your SQL Server environment uses SQL Server Authentication, enter the username and password used to connect to the repository. If your SQL Server environment instead uses Windows Authentication, click the checkbox and the current user’s Windows credentials are used to connect to the repository.
   NOTE: If the database does not already exist, this user must have the proper permissions to create a database on the SQL Server instance. Additionally, the user must have create table privileges to create the repository tables in that database.

6. Click Test Connection to verify that all the information entered is correct.

7. Click Finish.