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?

    Requires Free Membership to View

    By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

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

    All fields are required. Comments will appear at the bottom of the article.