Can not install service pack

Hi,
I have a win2k server running SQL2000. I have tried to install SP4 for SQL.
Evertything looks normal, but when I check the version it is still SP2. I
have compared the log file with another and there is a major differnce:
problem server:
09:57:26 Start Process...updating reg entries for SP
09:57:26 No Server -> Tools
Succesfully updated server:
14:46:11 Start Process...updating reg entries for SP
14:46:11 Default instance
Could this be the problem, and if so, how to solve this ?
Regards,
PanjoHi
The most common reasons for a SP not installing are either
Using the wrong download file
SQL2000-KB884525-SP4-x86-LLL.exe (Database Components SP4)
SQL2000.AS-KB884525-SP4-x86-LLL.exe (Analysis Services SP4)
SQL2000.MSDE-KB884525-SP4-x86-LLL.exe (Desktop Engine (MSDE 2000) SP4)
SQL2000-KB884525-SP4-ia64-LLL.exe (SQL Server 2000 SP4 (64-bit))
Unzipping the download but not running it
http://tinyurl.com/nbc9v
or Updating the wrong instance.
http://tinyurl.com/pmsvc
You also may want to stop/restart the server as a matter of course even if
you are not prompted to do so.
From the message it looks like SQL Server is not actually running on this
server, use NET START at a command prompt to verify this.
John
"panjo" wrote:
> Hi,
> I have a win2k server running SQL2000. I have tried to install SP4 for SQL.
> Evertything looks normal, but when I check the version it is still SP2. I
> have compared the log file with another and there is a major differnce:
> problem server:
> 09:57:26 Start Process...updating reg entries for SP
> 09:57:26 No Server -> Tools
> Succesfully updated server:
> 14:46:11 Start Process...updating reg entries for SP
> 14:46:11 Default instance
> Could this be the problem, and if so, how to solve this ?
> Regards,
> Panjo
>|||Hi,
I am quite sure I have the right downloadfile, my testserver is updated
succesfully. There is only one instance, so I can not update the wrong one.
Using net start confirms that mssqlserver and sqlserveragent are running.
I think some reg entry's are missing or wrong. I had some problems with this
server in the past. Then I run the SQL setup again, and did a registry
rebuild. Everything is working fine after that, except that I can not install
SP4.
Any idea which reg key's are checked during the install of SP4 ?
"John Bell" wrote:
> Hi
> The most common reasons for a SP not installing are either
> Using the wrong download file
> SQL2000-KB884525-SP4-x86-LLL.exe (Database Components SP4)
> SQL2000.AS-KB884525-SP4-x86-LLL.exe (Analysis Services SP4)
> SQL2000.MSDE-KB884525-SP4-x86-LLL.exe (Desktop Engine (MSDE 2000) SP4)
> SQL2000-KB884525-SP4-ia64-LLL.exe (SQL Server 2000 SP4 (64-bit))
> Unzipping the download but not running it
> http://tinyurl.com/nbc9v
> or Updating the wrong instance.
> http://tinyurl.com/pmsvc
> You also may want to stop/restart the server as a matter of course even if
> you are not prompted to do so.
> From the message it looks like SQL Server is not actually running on this
> server, use NET START at a command prompt to verify this.
> John
> "panjo" wrote:
> > Hi,
> >
> > I have a win2k server running SQL2000. I have tried to install SP4 for SQL.
> > Evertything looks normal, but when I check the version it is still SP2. I
> > have compared the log file with another and there is a major differnce:
> >
> > problem server:
> > 09:57:26 Start Process...updating reg entries for SP
> > 09:57:26 No Server -> Tools
> >
> > Succesfully updated server:
> > 14:46:11 Start Process...updating reg entries for SP
> > 14:46:11 Default instance
> >
> > Could this be the problem, and if so, how to solve this ?
> >
> > Regards,
> > Panjo
> >
> >|||Hi
I am not sure what keys would be checked, but you may want to try another
registry rebuilt. If you have group policies being applied you may want to
check what they are doing.
John
"panjo" wrote:
> Hi,
> I am quite sure I have the right downloadfile, my testserver is updated
> succesfully. There is only one instance, so I can not update the wrong one.
> Using net start confirms that mssqlserver and sqlserveragent are running.
> I think some reg entry's are missing or wrong. I had some problems with this
> server in the past. Then I run the SQL setup again, and did a registry
> rebuild. Everything is working fine after that, except that I can not install
> SP4.
> Any idea which reg key's are checked during the install of SP4 ?
> "John Bell" wrote:
> > Hi
> >
> > The most common reasons for a SP not installing are either
> >
> > Using the wrong download file
> > SQL2000-KB884525-SP4-x86-LLL.exe (Database Components SP4)
> > SQL2000.AS-KB884525-SP4-x86-LLL.exe (Analysis Services SP4)
> > SQL2000.MSDE-KB884525-SP4-x86-LLL.exe (Desktop Engine (MSDE 2000) SP4)
> > SQL2000-KB884525-SP4-ia64-LLL.exe (SQL Server 2000 SP4 (64-bit))
> >
> > Unzipping the download but not running it
> > http://tinyurl.com/nbc9v
> >
> > or Updating the wrong instance.
> > http://tinyurl.com/pmsvc
> >
> > You also may want to stop/restart the server as a matter of course even if
> > you are not prompted to do so.
> >
> > From the message it looks like SQL Server is not actually running on this
> > server, use NET START at a command prompt to verify this.
> >
> > John
> >
> > "panjo" wrote:
> >
> > > Hi,
> > >
> > > I have a win2k server running SQL2000. I have tried to install SP4 for SQL.
> > > Evertything looks normal, but when I check the version it is still SP2. I
> > > have compared the log file with another and there is a major differnce:
> > >
> > > problem server:
> > > 09:57:26 Start Process...updating reg entries for SP
> > > 09:57:26 No Server -> Tools
> > >
> > > Succesfully updated server:
> > > 14:46:11 Start Process...updating reg entries for SP
> > > 14:46:11 Default instance
> > >
> > > Could this be the problem, and if so, how to solve this ?
> > >
> > > Regards,
> > > Panjo
> > >
> > >