Performance Test Tool

Free tool for testing, tuning and optimizing queries for multiple concurrent connections
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:
First we need to find the name of the SQL Server service account:
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:
In this example, the name of the directory is: RemoteTraceDir
Give Read/Write access on the directory to the SQL Server service account:
In the Preferences for Performance Test Tool, enter the UNC path for the directory on the SQL Server:
You will now be able to use Performance Test Tool to connect to a remote SQL Server.