sql server reporting services: Renaming a SQL2005 - Unable to connect to RS from Management Studi -- sql server reporting services

Renaming a SQL2005 - Unable to connect to RS from Management Studi

Jeff Ericson
6/15/2006 10:23:19 AM

sql server reporting services:

We have several 2005 boxes that have been renamed. RS works fine from a
browser and I can deplopy reports to it and see it with the config manager.
What I can't do is reference it from Management Studio. On the one box that
I restarted after sp_drop and sp_add, a message box pops up referring to the
old name. on the other box, niether the old name no the new name are found.

RE: Renaming a SQL2005 - Unable to connect to RS from Management Studi

Jeff Ericson
6/15/2006 10:39:02 AM

For anyone who cares, I had to chnge the rsreportserver.config file. It was
referencing the old server names in the ulrroot section. This also impacted
the SAC tool's ability to manage the rs instance.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.