Q
Problem solve Get help with specific problems with your technologies, process and projects.

Configuring SQL Server with a changed computer name

Find out how to reconfigure all aspects of your SQL Server after your computer name has been changed.

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 last published in September 2008

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close