Showing posts with label win2k. Show all posts
Showing posts with label win2k. Show all posts

Friday, February 10, 2012

Can not install SP4 for SQL Server 7.0 on Win2k

In my case this is a SP4 install on a reinstall of SQL 7.0 with no user data
bases.
I have followed all the tips about turning off all non-essential services, e
tc., per the kb article and various other docs, but the 7.0 sp4 installation
still fails with the message
"One or more of your user databases have been marked read only, offline or s
uspect (not recovered). Correct the problem and restart setup."
The log files seem to show everything is ok but the install still fails.
I did try one additional test -- running the scm and osql commands shown at
the end of the sqlsp.log file.
When I ran the osql command, I get the expected results of 0 but also get an
additional message for the ODBC driver manager: "The driver doesn't support
the version of ODBC behavior that the application requested (see SQLSetEnvA
ttr)."
I suspect that this additional message is causing the failure.
(Running on W2k / SP4).
-- Vikram Jayaram [MS] wrote: --
* Look at the sqlsp.log for error messages
* It's a good idea to turn off all 3rd party and non-essential services
before you prform the Service Pack upgrade.
Thanks,
Vikram
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.How are you installing the setup for sp4. What does the sqlsp.log say? Are
you sure there are no other sql70 instances on the box?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Can not install SP4 for SQL Server 7.0 on Win2k

Our client applications have being generating timeout
exceptions persistently whiles connecting to SQL Server
7.0. I gathered from the web the problem is a known issue
with SQL Server 7.0 and is fixed in SP4. However,
whenever I try installing the service pack it gets stuck
in the first step and would not continue.
Could somebody offer me some assistance.
Thanks advance.* Look at the sqlsp.log for error messages
* It's a good idea to turn off all 3rd party and non-essential services
before you prform the Service Pack upgrade.
Thanks,
Vikram
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||In my case this is a SP4 install on a reinstall of SQL 7.0 with no user databases
I have followed all the tips about turning off all non-essential services, etc., per the kb article and various other docs, but the 7.0 sp4 installation still fails with the messag
"One or more of your user databases have been marked read only, offline or suspect (not recovered). Correct the problem and restart setup.
The log files seem to show everything is ok but the install still fails
I did try one additional test -- running the scm and osql commands shown at the end of the sqlsp.log file.
When I ran the osql command, I get the expected results of 0 but also get an additional message for the ODBC driver manager: "The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
I suspect that this additional message is causing the failure
(Running on W2k / SP4)
-- Vikram Jayaram [MS] wrote: --
* Look at the sqlsp.log for error message
* It's a good idea to turn off all 3rd party and non-essential services
before you prform the Service Pack upgrade
Thanks
Vikra
Vikram Jayara
Microsoft, SQL Serve
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups|||How are you installing the setup for sp4. What does the sqlsp.log say? Are
you sure there are no other sql70 instances on the box?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

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 instal
l
SP4.
Any idea which reg key's are checked during the install of SP4 ?
"John Bell" wrote:
[vbcol=seagreen]
> 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 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:
[vbcol=seagreen]
> 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 th
is
> 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 inst
all
> SP4.
> Any idea which reg key's are checked during the install of SP4 ?
> "John Bell" wrote:
>

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
> > >
> > >