October 9, 2008 at 9:03 am
With Carlton's help I've realized that I need to install SQL Server Reporting Services onto our new database server. However, being a neophyte DBA I believe I've made a mistake. I've got into the SSRS Configuration tool to set up SSRS the same way (or at least nearly the same way) as it is setup on the old database server. However, I see 3 items in the SSRS Configuration tool which indicate that it isn't setup and it appears as though I can't set them up. These are: (1) the Report Manager Virtual Directory, (2) Web Service Identity and (3) the Database Setup. On the old server all 3 are configured. I tried setting up one of them, but it didn't look as though it was setup at all.
I think I made a mistake when copying over the user databases onto the new server. I naively thought that I should also copy the ReportServer and ReportServerTempDB databases, because I thought those were "user" databases, from the old server to the new server. I'm wondering if that might be what's preventing me from properly configuring these databases? If I am correct about this, then how do I fix it? Do I have to do something like this:
1) Uninstall SSRS from the new server.
2) Drop both ReportServer and ReportServerTempDB databases from the new server.
3) Then attempt to configure SSRS through the SSRS Configuration tool.
Or do I do something else?
Kindest Regards, Rod Connect with me on LinkedIn.
October 9, 2008 at 11:35 am
OK, I've found a MSDN article titled Moving the Report Server Databases to Another Computer which described, for SQL Server 2005, how to move SSRS from one server to another. (I'm sorry, but I'm really new at this stuff, and I ignorantly thought that the databases ReportServer and ReportServerTempDB were somehow or other user databases. My bad.)
Anyway, so I went ahead and did what was described in the referenced article, and it required that I create a virtual directory for Reporting Services, which I think I did in the Reporting Services Configuration Tool. After doing that, I went back and tried to set up the Database Setup and Web Service Identity items in the Reporting Services Configuration Tool. I used the "sa" account, rather than my own account, to have it run under. That seemed to work, because the Reporting Services Configuration Tool now reports both the Database Setup and the Web Service Identity items as being configured. However, I got an error when doing those that said:
"Failed on 'Assigning Reporting Services Rights to User'"
I would assume that in this case the user invovled in the "sa" account. What is wrong and what do I do about it?
Kindest Regards, Rod Connect with me on LinkedIn.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply