Chasen Bettinger Chasen Bettinger - 4 months ago 22
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.

From: https://msdn.microsoft.com/en-us/library/ms156450.aspx

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

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

Comments