Thursday, June 12, 2008

Reporting Services adjustment after hostname change - why you change hostname!?

Well, why I changed hostname after installed reporting services on my pc? because my corporate IT changed in order to join to domain so I did not have any choice.
BTW if you encounter same situation, easiest way is i think re-install reporting services but i am lazy so i have tried to find something tweaks. I googled and first i found was this one.

Original - James Kovacs' Weblog - Report Manager cannot find root folder after installation
Steps to Resolve the ProblemFirst verify that this is in fact your problem. Launch SQL Query Analyzer and run the following script: -- Start scriptsp_helpserver GO-- End script Note the hostname that SQL Server reports. If this doesn't match your computer's hostname, you need to change it. (I'll assume that you know your computer's hostname or how to find it in My Computer... Properties.) If the hostnames don't match, here's a script to correct the problem. You'll have to substitute appropriate values for OLDNAME and NEWNAME in the script below. N.B. The parameter 'local' in sp_addserver is important as it tells SQL Server that this is its hostname rather than the hostname of a linked server. -- Start scriptsp_dropserver 'OLDNAME'GOsp_addserver 'NEWNAME', 'local'GOsp_helpserverGO-- End script sp_helpserver should now report the correct hostname. Since SQL Server only reads its hostname information at startup, you'll have to restart SQL Server for these changes to take effect. Once you've restarted SQL Server, Report Manager should be working again.

Okay so i fired above script and restarted SQL Server and Reporting Service services and tried but still cannot open report manager. Then next what i did was i opened Reporting Services Configuration Manager. You also find old hostname on here under Database Setup section. Server name was 'old hostname\instance' so i changed it. Clicked apply button then another error message on Task Status block said 'Assigning Reporting Services Rights to User' with red x symbol. Click the link 'Tell me more about the problem and how to resolve it.', it was saying because my all SQL Server 2005 pre-define local groups and users were also using old hostname like 'old hostname\ASPNET' but RS configuration manager tried to find 'new hostname\ASPNET'.

Opened Local Users and Groups and renamed all groups name which contain old hostname. Also went back to MSSMS and changed all names under Security-Logins.

After restarted SQL Server and Reporting Services, I could open Report Manager page.

But I still could not connect Reporting Services from MSSMS. In order to resolve this, I changed RSReportServer.config file which is saved on report manager's physical folder. http://old hostname/reportserver replaced to new hostname.

Now all my reporting services related applications are working fine.

0 comments: