Connect to a remote SQL Server

Performance Test Tool can be run on a different computer than the SQL Server. This tutorial will show you how to connect to a remote SQL Server.

To be able to perform remote performance tests, a network share must be created where the SQL Server service account has write access. This tutorial will show, how to create this share on the SQL Server.

Note, if the SQL Server service account is a domain account, the share can also be created on the local machine running Performance Test Tool, giving the SQL Server service account (or Everyone depending on security) read/write access to the share.

If trying to connect to a remote SQL Server without the proper configuration, the following will show:
TutorialRemote_1.png

First we need to find the name of the SQL Server service account:
TutorialRemote_2.png
The name of the SQL Server service account in this example is: NT Service\MSSQL$SQL2014

Create a directory on the SQL Server and choose to share the directory:
TutorialRemote_3.png
In this example, the name of the directory is: RemoteTraceDir

Give Read/Write access on the directory to the SQL Server service account:
TutorialRemote_4.png

In the Preferences for Performance Test Tool, enter the UNC path for the directory on the SQL Server:
TutorialRemote_5.png

You will now be able to use Performance Test Tool to connect to a remote SQL Server.

Last edited Nov 16, 2016 at 4:29 PM by larshove, version 3