Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In the directory where you downloaded the application, create a new file called servers.csv with the connection strings required details for all of the SQL Server instances you would like to collect data from. This file can be created with Notepad, Excel, or any text editor. One Each SQL Server instance should be one per have its own line, and there is no limit to the number of SQL Servers.

The recommended connection string format is:

Code Block
sqlserver://<username>:<password>@<ip>:<port>?database=sqltelemetrydbipOrDNS,port,username,password,database
  • <username>:<password>: leave this section unchanged

  • <ip>:<port>: Replace this with the actual IP address and port number

  • database=sqltelemetrydb: Replace sqltelemetrydb with the database name

  • username,password: Replace these with the username and passwordipOrDNS: The IP address or DNS of the SQL Server instance

  • port: The port on which SQL Server is running

  • username: Username for authentication

  • password: Password for authentication

  • database: The default database to connect (e.g., master)

Run sqlserver-telemetry

Windows

...