Last week, one of the servers I was helping to manage got its machine name changed. However, not all the configurations for all the programs were changed as well. So all those applications with the old settings started crying out for help.
One of it was SQL Reporting Services (SSRS). In SSRS 2005, the reporting services configuration manager showed you a little tick icon
In SSRS 2008, those little icons are gone.
Viewing my trusty Report Manager yielded this cry for help.
No permission setting changed, so what's the deal?
Well, apparently a lot of the settings for SSRS was set to use the machine name previously. If you go to the Database item of the configuration manager, you'll understand what I mean.
How to resolve?
1. Correct the entries in sys.servers - you'll have to run the following statement into as many database servers as you have
EXEC sp_dropserver @server = <oldname> EXEC sp_addserver @server = <newname> |
2. Update the settings in configuration manager, so set the new servername. Just run through the database portion as you normally would in setup.
After that, "Bob's your uncle" as my English friends would say...
No comments:
Post a Comment