Chasen Bettinger Chasen Bettinger - 1 year ago 242
SQL Question

SSRS 2016 Connection String for Non-Local Server

I am trying to connect to a server that is not locally stored on my reporting server.


I am trying to use: Data Source=localhost\MSSQL13.; Initial Catalog=AdventureWorks

However, my data source is not on the localhost. What is the correct path I need to be using for my server to connect? I have the instance path, but it is in a localized format. (EX. D:\MSSQLSERVER...)

Answer Source

Use the name of the remote SQL Server as the Data Source in your connection string.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download