Configuring SQL Server with a changed computer name
I recently changed my computer name, and since then the SQL Server Development Studio could no longer deploy my project. It successfully builds the project, but when I attempt to deploy, it returns the following error message:
"A connection could not be made to the report server 'http://localhost/Reports$NAME'
Additional Information: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)"
Changing the computer name back does not help, and when I open the SQL Server Reporting Services (SSRS) Configuration Manager, it connects successfully. Do you know what might be wrong?
You should go into Business Intelligence Development Studio (BIDS) and edit the TargetServerURL. Check to see what that parameter is set to, and adjust it to point to the Reports virtual directory with the proper host name that now exists for your machine or server. Also, be certain to open your Internet Information Services (IIS) administrator panel to ensure that the web server is running, along with checking the existence of the Reports virtual directory where SSRS will look to store and execute your reports.
This was first published in September 2008
Join the conversationComment
Share
Comments
Results
Contribute to the conversation