Please Help!! New SQL Server 2005 DBA.

Last Post 09 Mar 2009 08:20 AM by pk48rocketmailcom. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
pk48rocketmailcom
New Member
New Member

--
09 Mar 2009 08:20 AM
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 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.
You are not authorized to post a reply.

Acceptable Use Policy