Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 694
  • Last Modified:

Reporting Services Install Error: The Report Server requires SQL Server 2000 with Service Pack 3a

I have SQL Server 2000 install on my computer, which is running Windows XP Professional with SP2 installed. To install SQL Server 2000's service pack 3a, I downloaded and installed the following three files from Microsoft web site:

sql2ksp3.exe
sql2kasp3.exe
sql2kdesksp3.exe

All three installed OK and did not report any problems.

I now want to install the Reporting Services evaluation, so I downloaded RSEVAL.exe from the Microsoft web site.  After it unpacks everything it starts the installation. When it gets to the point where it wants to create the report server it gives me the following error and refuses to go further:

The Report Server requires SQL Server 2000 with Service Pack 3a.

My questions:
* How, in SQL Server, can I verify that it is running SP3a?
* What do I need to do to get past this problem?
0
rgrimm
Asked:
rgrimm
  • 3
  • 3
2 Solutions
 
ram2098Commented:
can you check the version of your sql server?

In Query Analyzer,

Please run "SELECT @@VERSION" and can you paste the output?
0
 
rgrimmAuthor Commented:
Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: )
0
 
rgrimmAuthor Commented:
What in the @@VERSION will tell me if it is SP3a?
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
jdlambert1Commented:
You can get a little more with "exec master..xp_msver" than with @@version, but still not the name of the latest service pack, just the number.

Here's how the version number match up to service packs for SQL Server 2000:
8.00.760 = SP3
8.00.534 = SP2
8.00.384 = SP1
8.00.194 = no service pack
0
 
ram2098Commented:
So, Looks like, you have SP3 installed. I have setup the same rseval.exe some time back with the same version.

May be problem with the paramters you are passing with the installation. Are you giving the same sql server name when you run the installation?

Sorry..Am I asking you many questions? :)  Just want to make sure we are not overlooking something here.
0
 
ram2098Commented:
I mean ...the same sql server where you installed SP3. Also, have you rebooted your server after SP3 installation? Probably you can try that too.
0
 
rgrimmAuthor Commented:
I inerrantly ran @@Version on the wrong SQL Server. Here is the output from the correct SQL Server:

Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

This reports the correct version number of SQL Server as SP3, however it is a Personal Edition (MSDE). In checking the requirements for Reporting Services I find that it requires Standard Edition with SP3 as a minimum. So I need to install the Standard Edition before I can install Report Services. That should resolve my issue.

BTW, I found in the SP3 Readme another T-SQL function that returns the Service Pack version that is in use:

SELECT ServerProperty('ProductLevel')

It returns:  SP3
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now