Can't connect to Reporting Services after I rename my computer -- sql server reporting services

csoprasanna NO[at]SPAM gmail.com
5/11/2006 5:46:07 PM

Hi,

I have installed SQL 2005 on my Windows 2003 box. After I install SQL
2005, I have configured the Reporting Services and I can connect using
the Management Studio. I had to rename my machine and after I renamed I
can still connect to Database Services from Management Studio. However
I am getting error while I connect to Reporting Services. I have also
tried sp_dropserver <old> and sp_addserver <new>,'local'. It still
doesn't help.

Can someone help me out with fixing this issue.

Thanks,
Prasanna.

Alan Z. Scharf
5/12/2006 10:24:12 AM

Prasanna,

When I had the same problem, I ran RSConfig.exe.
Check it for the apprpriate paraemters.

Alan

[quoted text, click to view]

sql server reporting services : Can't connect to Reporting Services after I rename my computer