I renamed the computer name for the server running both SQL Server and
Reporting Services. I used sp_dropserver and sp_addserver to correct the
servername for SQL Server, but now I cannot use the Management Studio to
connect to the Reporting Server. I am running SQL 2005. Any ideas how to
fix the name without re-installing?
Thanks,
MattThe Reporting Services Configuration Manager tool has a Database Setup tab
that you can use to set the server name for the ReportServer database
repository.
Steve MunLeeuw
"Matthew Bando" <MatthewBando@.discussions.microsoft.com> wrote in message
news:D3CF59E6-B63C-4B7D-9C0B-DED2357DF561@.microsoft.com...
>I renamed the computer name for the server running both SQL Server and
> Reporting Services. I used sp_dropserver and sp_addserver to correct the
> servername for SQL Server, but now I cannot use the Management Studio to
> connect to the Reporting Server. I am running SQL 2005. Any ideas how to
> fix the name without re-installing?
> Thanks,
> Matt
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment