We help IT Professionals succeed at work.
Get Started

Issue connecting to a data source after moving SSRS to a new server

127 Views
Last Modified: 2020-02-05
I recently moved SSRS to a new server.  The migration went fairly well and most of the reports are running fine on the web server.  I've been going through each project to point the project  to the new report server location and then updating the connection string on shared data sources to again point to the new server.  Almost all of my data sources point to one of 2 catalogs (one for finances and one for fundraising) and I have successfully updated many of the projects without an issue for both catalogs.  However, I have a folder that uses both data sources.  I've made all the changes to point to the new server and when I test the connection string, it is successful.  However, if I try and run the query for the financial data source, it errors out with the following error (last paragraph).  If I turn on the old SSRS server, it works fine.  I've checked and double checked that everything points to the new server and it does.  Again, this data source is used in other projects and works fine there - just not in this one project.  I've even deleted and recreated the data source and it still won't work.  I can't figure out what the problem is... and feel the error is misleading.  

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Comment
Watch Question
Director of IT
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant

An Experts Exchange subscription includes unlimited access to online courses.

Get Started
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE