SSRS2000 to 2005 RSExecRole - SQL Server Forums

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

Analysis Server and Reporting Services (2005)

SSRS2000 to 2005 RSExecRole

Author

Topic

hey001us
Posting Yak Master

185 Posts

Posted - 2008-04-09 : 17:55:57

We are upgrading SQL2000 to 2005 database at new server.
I used to backup and restored method to transfer all databases etc. (Side by Side method)

In the same manner I did for SSRS, but when I try to upgrade the database from 2000 to 2005 through RSCM. I am getting following error.

Cannot find the user 'RSExecRole', because it does not exist or you do not have permission

Both Master, and Report Server got RSExecRole.

I am not sure what I am missing here. Can any anyone help me?

hey

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-09 : 18:03:14

Did you manually apply in Report Server database.
I did like this:

http://forums.microsoft.com/Forums/ShowPost.aspx?PostID=2980965&SiteID=1

hey001us
Posting Yak Master

185 Posts

Posted - 2008-04-09 : 18:10:32

yes, I am upgrading manually. But SP2 for what? SQL2000 got SP2 but SQL2005? Bit confused here...

hey

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-09 : 19:13:03

Did you read the article carefully? We have upgraded from SQL 2000 SP3 to SQL 2005 SP2.

hey001us
Posting Yak Master

185 Posts

Posted - 2008-04-09 : 23:15:35

Hi,
Thanks much for your reply. I fixed the problem, and working fine.

hey

hey001us
Posting Yak Master

185 Posts

Posted - 2008-04-09 : 23:19:35

I still used backup and restore methoed. but need to give role access for both ReportServer and ReportServerTempDB database. Thanks much for your support

hey

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-09 : 23:28:59

OK its working now.

Tell what you did step-by step? So people will know what to do.

hey001us
Posting Yak Master

185 Posts

Posted - 2008-04-10 : 00:40:18

Based on my case I prepared this. It may differ case to case.
But link here is very clear. http://msdn2.microsoft.com/en-us/library/ms143724.aspx.

Step1: Backup all dbf file from SQL2000 Server and Back up the symmetric key for the report server database. Use the rskeymgmt utility to perform this operation.

Step2: Go to SQL2005 Server stop the Report Server Service before restoring the SSRS DB

Step3: Configuration of SSRS using Reporting Services Configuration Manager. Setup the below all:
- Report Server Virtual Directory: – Default is “ReportServer”
- Report Manager Virtual Directory: – Default is “Reports”
- Windows Service Identity: - Service Name: ReportServer
Service Account: NT Authority\NetworkService
Build in Service: Network Service
- Web Service Identity:- ASP Account - NT Authority\NetworkService
Report Server – ReportServer
RM - Report
- Database :- connect to right database
- Encryption:- make sure backup the key before deleting

Step4: Restore the both Databases from Step1 (you need to clear all the activities if you got error “used”)

Step5: restore the key and start SSRS

Step6: run the scrip to create all logins from SQL 2000 server.

Step7: Give 'RSExecRole' for Reportserver and ReportserverTempdb

Step7: Restart the SSRS and make sure Initialization got tick mark else report server got problem.

Encryption key issue may get rsReportServerNotActivated or rsOperationNotSupported if not correct

hey

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources