Chasen Bettinger Chasen Bettinger - 1 year ago 141
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.