Wednesday, February 15, 2012

Error running script:sp1_serv_uni.sql(1)

I have a SQL 2000 Server Standard Edition. When I tried to install service
pack 1, 2, or 3, it stopped the installation itself with the above error.
Can anyone help me please?
Thanks and regards,
Jacky
jackykit@.hotmail.comKeroppi,
Can you post the log file, or preferably, the relevant portions of the
log? The file should be called sqlstp.log and their may be some
information in the SQL Server ERRORLOG file.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Keroppi wrote:
> I have a SQL 2000 Server Standard Edition. When I tried to install servic
e
> pack 1, 2, or 3, it stopped the installation itself with the above error.
> Can anyone help me please?
> Thanks and regards,
> Jacky
> jackykit@.hotmail.com|||Sorry, I locate the sqlstp.log but it's not the updated one so I extract som
e
information from errorlog in C:\Program Files\Microsoft SQL Server\MSSQL\LOG
.
2005-01-06 14:06:19.21 server 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.0 (Build 2195: Service Pack 4)
2005-01-06 14:06:19.21 server Copyright (C) 1988-2002 Microsoft
Corporation.
2005-01-06 14:06:19.21 server All rights reserved.
2005-01-06 14:06:19.21 server Server Process ID is 4072.
2005-01-06 14:06:19.21 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2005-01-06 14:06:19.23 server SQL Server is starting at priority class
'high'(1 CPU detected).
2005-01-06 14:06:19.28 server SQL Server configured for thread mode
processing.
2005-01-06 14:06:19.28 server Using dynamic lock allocation. [2500] L
ock
Blocks, [5000] Lock Owner Blocks.
2005-01-06 14:06:19.29 server Attempting to initialize Distributed
Transaction Coordinator.
2005-01-06 14:06:21.35 spid3 Starting up database 'master'.
2005-01-06 14:06:21.53 spid5 Starting up database 'model'.
2005-01-06 14:06:21.53 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-01-06 14:06:21.56 spid3 Server name is 'SUN426'.
2005-01-06 14:06:21.68 spid8 Starting up database 'msdb'.
2005-01-06 14:06:21.68 spid9 Starting up database 'pubs'.
2005-01-06 14:06:21.68 spid10 Starting up database 'Northwind'.
2005-01-06 14:06:21.68 spid11 Starting up database 'SUNDB'.
2005-01-06 14:06:21.81 server SQL server listening on 10.168.1.11: 1433.
2005-01-06 14:06:21.81 server SQL server listening on 127.0.0.1: 1433.
2005-01-06 14:06:21.87 server SQL server listening on TCP, Named Pipes.
2005-01-06 14:06:21.87 server SQL Server is ready for client connections
2005-01-06 14:06:22.29 spid5 Clearing tempdb database.
2005-01-06 14:06:22.32 spid9 Starting up database 'db_ControlManager'.
2005-01-06 14:06:23.68 spid5 Starting up database 'tempdb'.
2005-01-06 14:06:23.96 spid3 Recovery complete.
2005-01-06 14:06:23.96 spid3 SQL global counter collection task is
created.
2005-01-06 14:06:37.71 spid52 Using 'xpsqlbot.dll' version '2000.80.194'
to execute extended stored procedure 'xp_qv'.
2005-01-06 16:24:14.71 spid68 Starting up database 'sqlbpa'.
2005-01-06 16:50:36.17 spid68 Using 'xpstar.dll' version '2000.80.760' to
execute extended stored procedure 'sp_MSgetversion'.
2005-01-06 16:50:42.60 spid68 Error: 15457, Severity: 0, State: 1
2005-01-06 16:50:42.60 spid68 Configuration option 'show advanced
options' changed from 1 to 1. Run the RECONFIGURE statement to install..
2005-01-06 16:50:42.79 spid68 Using 'xplog70.dll' version '2000.80.760'
to execute extended stored procedure 'xp_msver'.
"Mark Allison" wrote:

> Keroppi,
> Can you post the log file, or preferably, the relevant portions of the
> log? The file should be called sqlstp.log and their may be some
> information in the SQL Server ERRORLOG file.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Keroppi wrote:
>|||I also attached 2 files for your reference.
Thanks in advance.
Keroppi
"Keroppi" <Keroppi@.discussions.microsoft.com> glsD:C7E6819B-824B-40EC-BF57-4FC2F4B
35580@.microsoft.com...[vbcol=seagreen]
> Sorry, I locate the sqlstp.log but it's not the updated one so I extract s
ome
> information from errorlog in C:\Program Files\Microsoft SQL Server\MSSQL\L
OG.
>
>
> 2005-01-06 14:06:19.21 server 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.0 (Build 2195: Service Pack 4)
>
> 2005-01-06 14:06:19.21 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2005-01-06 14:06:19.21 server All rights reserved.
> 2005-01-06 14:06:19.21 server Server Process ID is 4072.
> 2005-01-06 14:06:19.21 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2005-01-06 14:06:19.23 server SQL Server is starting at priority class
> 'high'(1 CPU detected).
> 2005-01-06 14:06:19.28 server SQL Server configured for thread mode
> processing.
> 2005-01-06 14:06:19.28 server Using dynamic lock allocation. [2500]
Lock
> Blocks, [5000] Lock Owner Blocks.
> 2005-01-06 14:06:19.29 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2005-01-06 14:06:21.35 spid3 Starting up database 'master'.
> 2005-01-06 14:06:21.53 spid5 Starting up database 'model'.
> 2005-01-06 14:06:21.53 server Using 'SSNETLIB.DLL' version '8.0.766'.
> 2005-01-06 14:06:21.56 spid3 Server name is 'SUN426'.
> 2005-01-06 14:06:21.68 spid8 Starting up database 'msdb'.
> 2005-01-06 14:06:21.68 spid9 Starting up database 'pubs'.
> 2005-01-06 14:06:21.68 spid10 Starting up database 'Northwind'.
> 2005-01-06 14:06:21.68 spid11 Starting up database 'SUNDB'.
> 2005-01-06 14:06:21.81 server SQL server listening on 10.168.1.11: 1433
.
> 2005-01-06 14:06:21.81 server SQL server listening on 127.0.0.1: 1433.
> 2005-01-06 14:06:21.87 server SQL server listening on TCP, Named Pipes.
> 2005-01-06 14:06:21.87 server SQL Server is ready for client connection
s
> 2005-01-06 14:06:22.29 spid5 Clearing tempdb database.
> 2005-01-06 14:06:22.32 spid9 Starting up database 'db_ControlManager'.
> 2005-01-06 14:06:23.68 spid5 Starting up database 'tempdb'.
> 2005-01-06 14:06:23.96 spid3 Recovery complete.
> 2005-01-06 14:06:23.96 spid3 SQL global counter collection task is
> created.
> 2005-01-06 14:06:37.71 spid52 Using 'xpsqlbot.dll' version '2000.80.194
'
> to execute extended stored procedure 'xp_qv'.
> 2005-01-06 16:24:14.71 spid68 Starting up database 'sqlbpa'.
> 2005-01-06 16:50:36.17 spid68 Using 'xpstar.dll' version '2000.80.760'
to
> execute extended stored procedure 'sp_MSgetversion'.
> 2005-01-06 16:50:42.60 spid68 Error: 15457, Severity: 0, State: 1
> 2005-01-06 16:50:42.60 spid68 Configuration option 'show advanced
> options' changed from 1 to 1. Run the RECONFIGURE statement to install..
> 2005-01-06 16:50:42.79 spid68 Using 'xplog70.dll' version '2000.80.760'
> to execute extended stored procedure 'xp_msver'.
>
>
>
> "Mark Allison" wrote:
>

No comments:

Post a Comment