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 2000 Forums
 SQL Server Development (2000)
 SQL Reporting Services

Author  Topic 

NTSGDev
Starting Member

1 Post

Posted - 2005-03-10 : 15:32:29
I am attempting to install SQL Reporting Services on a machine that has SQL 2000 SP3A. I am attempting to store the Reporting Services Database on another machine that already has SQL Reporting Services present. According to the install program, if the target DB already has a SQL Reporting Services DB on it, then it will be used by the install. The target machine also has SQL 2000 SP3A on it. Both return exactly the same version when doing SELECT @@VERSION. However, when I identify the SQL Server (which is not a named instance) and click Next, I get the following error message:

"The report server database is a different version and cannot be used for this installation"

and I cannot get past it. Does anyone have any idea why I might be getting this or how I can get around it?

Thanks ahead of time :)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-03-10 : 17:58:10
To get around it, simply delete the ReportServer and ReportServertempdb databases. Then try your install again. Deleting the ReportServer database though will delete all reports that you have already in there.

Tara
Go to Top of Page
   

- Advertisement -