Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SP2 Upgrade Help

Author  Topic 

ddamico
Yak Posting Veteran

76 Posts

Posted - 2008-09-19 : 09:08:24
I am a pretty new DBA and have been tasked with upgrading SQL Server 2005 to SP2. My dilemna is this. Previously some old DBA had upgraded to SP2 on a system that was using Reporting Services after the upgrade SSRS would not work for the reports.

I have read in emails that one person reconfigured SSRS after the upgrade and another wrote they had to drop and re-add the user database user logging in to the database. That was all they wrote, know one quoted a URL or any documentation on what they did.

I am hoping someone has been through this and could at least point me to some documentation or link that would help me. I have nad no luck googling for the answer and don't want to have the reports rendered unusuable as the system is production. Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-19 : 10:03:39
Never had that issue with SP2 . Infact, it solved our reporting issues with PDF Sizing larger than Excel after applying SP2.

Check out Microsoft links for what issues are solved with SQL Server SP2.
Go to Top of Page
   

- Advertisement -