Avatar of cindyfiller
cindyfiller
Flag for United States of America asked on

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

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)
Microsoft SQL ServerMicrosoft Server OSSSRSSQL

Avatar of undefined
Last Comment
cindyfiller

8/22/2022 - Mon
David Johnson, CD

is named pipes provider enabled? 

https://blogs.msdn.microsoft.com/sql_protocols/2007/03/31/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server/

cindyfiller

ASKER
Yes named pipes are enabled.  This same dataset is used successfully in many other projects, so it doesn't make sense that it works there and not this project...  I don't think it is a configuration issue.  It seems like it would be something specific to this project??
ASKER CERTIFIED SOLUTION
cindyfiller

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes