|
Home > Archive > MS SQL Server > August 2005 > After applied Service Pack, the SQL Product Version didn't change
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
After applied Service Pack, the SQL Product Version didn't change
|
|
|
| Dear Sir,
I have a server with one SQL 2000 Instance <Enterprise version>, after
applied SP3a <I tried also SP4>, success, restarted, the Product version is
still 8.00.194<RTM>.
How come the service pack didn't take effect? I am using an local admin.
acct already. Also, I can't successfully install Report Service as it
required SP3a!
Any idea? Many thanks!
| |
| John Bell 2005-08-30, 3:23 am |
| Hi Henry
How are you checking the version number?
It seems like there may have been a problem installing the service pack, but
you should have been notified that it failed. Check the sqlsp.log in the
windows or winnt directory and the information in the Sql Server Log file.
It could be that you have multiple instances in which case you need to
upgrade all of them.
Make sure that you are trying to install the correct service pack file and
also that you are not just unzipping them!
John
"Henry" wrote:
> Dear Sir,
> I have a server with one SQL 2000 Instance <Enterprise version>, after
> applied SP3a <I tried also SP4>, success, restarted, the Product version is
> still 8.00.194<RTM>.
> How come the service pack didn't take effect? I am using an local admin.
> acct already. Also, I can't successfully install Report Service as it
> required SP3a!
> Any idea? Many thanks!
>
|
|
|
|
|