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.com
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 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.com
|||Sorry, I locate the sqlstp.log but it's not the updated one so I extract some
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] 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 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-4FC2F4B35580@.microsoft.com...[vbcol=seagreen]
> Sorry, I locate the sqlstp.log but it's not the updated one so I extract some
> 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] 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 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:

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

Error running script: sp1_serv_uni.sql(1), while installing SP3(sql2ksp3)

Thanks for the reply.
The link which you have given me, I went to that page but
the solution they gave is to install the latest service
pack or a work around solution, I was trying to install
the latest service pack itself not the service pack 1,the
solution they gave is for servive pack 1 not for service
pack 3, so do you have any idea what I should do.
Please mail me a response.
Regards,
Jyotshna.
--Original Message--
this error may occur if the master database files have
been moved from the
orignal installation location.
check the following link:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q308753
regards,
Harsh.
"Jyotshna Vonguru" <jyotshna.vonguru@.icn.siemens.com>
wrote in message
news:568701c3e51c$aefe4410$a401280a@.phx.gbl...
Hello,
I am getting an error called:
Error running script: sp1_serv_uni.sql(1), while
installing service pack 3(sql2ksp3).
Could anybody tell me, how to correct this.
Is there anyway.
Please give me a quick solution.
Thank you,
Jyotshna.Please find the corresponding *.out file to see a detailed error mesage.
Thanks,
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.|||I'm having the exact same problem.
No one has been able to help me.
Would I be correct in guessing that this is on a Windows 2003 Server, and
its a fresh install of SQL 2000.
Dave.|||I too am getting the same problem.
The *.out file says (1 row affected)
Thats it.
This is driving me made, as I have 3 x 2003 Servers I am building with SQL 2
000 on them, and am getting exactly the same error on all 3.|||What does the sqlstp.log say?
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.