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...)
Use the name of the remote SQL Server as the
Data Source in your connection string.