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.
1. What is happening here? How could the Reporting Services be running but Reporting Server database4s 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.