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.
| Author |
Topic |
|
pk48rocketmailcom
Starting Member
1 Post |
 Posted - 2009-03-09 : 11:31:01
|
| Hi,I am a new SQL Server 2005 DBA.We have SQL Server 2005 (SP1) on our servers.I have to do the following:1. Install SQL Server Reporting Services.2. Install SP3 of SQL Server 2005.First I went to the Server and checked all the services that were running. I found that SQL Server Reporting Services (MSSQLSERVER) is running on the Server. Then I checked all the databases that were installed. I did NOT find the two databases installed for Reporting Server. These are: ReportServer and ReportServerTempDB.My questions:1. What is happening here? How could the Reporting Services be running but Reporting Server databases not be installed. Why are the two Reporting Server databases not created. What should I do to install Reporting Server? Put in the Reporting Server DVD and just run? (Of course, I will do this during off hours)? Any tips or pointers. Any help appreciated.2. Installing SP3. Should I first install Reporting Server and then SP3. Or does the order of install matter? Once again, any help appreciated. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-09 : 12:27:54
|
| 1) It's because you have chosen to manually configure Reporting services instead of default option. Use Report Configuration to acknowledge that.2)You can use SP3 after the fact. |
 |
|
|
|
|
|
Please Help. New to SQL Server DBA.