Wednesday, March 7, 2012

Reporting Services Error - SQL Server does not exist or access denied

Hi, I am unable to view my reports once deploying them. The error I get in Report Manager is SQL "Server does not exist or access denied". What is weird about this is that I am able to run the reports within the preview tab (in visual studio .net 2003). When I try to use the same connection string in Report Manager I get the error. Please note that I deploy the reports from my computer onto a different server where I am trying to access them. This problem started after installing some critical windows updates onto my local computer and it is driving me crazy. If anyone could suggest a course of action it would be greatly appreciated - so far I have not been able to make sense of what the problem is.
Thanks.Problem Solved - the database was using port 2433 - so i just changed that in my connection string.

No comments:

Post a Comment