I have a new Win2K SP2, SQL Server 2K installation.
When I install SP1 I get the following message
Error running script: sp1_repl.sql(1)
Has anyone come across this before?
Try stopping all services except alerter,comp.browser,event
log,license logging serv,messngr,net logon,NT lm sec.supp prov,plug and
play,rem proc call loc,RPC serv,server,spooler,tcp/ip netbios helper,time
service and workstation.
Microsoft Certified Solutions Provider
Providing expertise in hosting applications
More Tips at: http://www.intermedia.net/support/kb/
Windows 2000 Web Hosting: http://www.intermedia.net/
For a waiver of the set up fee use "IMFREE" code
Free MIS Relief Offered To World Trade Center Businesses
Quote:> I have a new Win2K SP2, SQL Server 2K installation.
> When I install SP1 I get the following message
> Error running script: sp1_repl.sql(1)
> Has anyone come across this before?
If you are still having this problem, try the following:
1. Delete the Registry Key (if this is a default instance): (please be
cautious while using the registry)
Server\<InstanceName>\setup\resume" (for a named instance)
2. Log on to the box as the domain account who is a member of the NT local
admins group AND who is a member of the sysadmin SQL Role.
3. Stop all the non default services like: ALL SQL Services/All IIS-related
services/SNMP/BACKUPEXEC/BMC Patrol or other software that could attempt to
restart other services or lock any related files and also stop any
anti-virus programs you have running as well.
4. Also stop any applications running on that machine because they could
potentially lock some files if they are in use and this would prevent any
updates to the files. Removal of the RESUME key results in restarting the
service pack from the beginning instead of from the point of failure.
If it fails again with the same error, you may want to look at the
sp1_repl.out file for more information and also post it.
Hope this helps.
Please respond to newsgroups only.
Ive been "encouraged" to share this helpful information from our lawyers.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
| Subject: SQL 2K SP1 Fails to install sp1_repl.sql
| Date: Mon, 1 Oct 2001 14:15:37 +0100
| Lines: 14
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
| NNTP-Posting-Host: firewall.pearsoned-ema.com 126.96.36.199
| Path: cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04
| Xref: cppssbbsa01.microsoft.com microsoft.public.sqlserver.server:175441
| X-Tomcat-NG: microsoft.public.sqlserver.server
| I have a new Win2K SP2, SQL Server 2K installation.
| When I install SP1 I get the following message
| Error running script: sp1_repl.sql(1)
| Has anyone come across this before?
Of course, this posting wouldn't be complete without a nice, juicy
disclaimer from our lawyers: This posting is provided "AS IS" with no
warranties, and confers no rights. You assume all risk for your use. ? 2001
Microsoft Corporation. All rights reserved.
| X-Tomcat-ID: 345346258
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| Organization: Microsoft
| Date: Tue, 16 Oct 2001 19:23:29 GMT
| Subject: Re: SQL 2K SP1 Fails to install sp1_repl.sql
| X-Tomcat-NG: microsoft.public.sqlserver.setup
| Newsgroups: microsoft.public.sqlserver.setup
| Lines: 10
| Path: cppssbbsa01.microsoft.com
| Xref: cppssbbsa01.microsoft.com microsoft.public.sqlserver.setup:32653
| NNTP-Posting-Host: tide72.microsoft.com 188.8.131.52
| Check out the sp1_repl.out file of more info and post it
| Vishal Anand
| Microsoft SQL Server Support
| Of course, this posting wouldn't be complete without a nice, juicy
| disclaimer from our lawyers: This posting is provided "AS IS" with no
| warranties, and confers no rights. You assume all risk for your use. ?
| Microsoft Corporation. All rights reserved.
The sp1_repl.out" file indicates a problem as follows:
Creating procedure sp_MScreate_mergesystables
Cannot add rows to sysdepends for the current stored procedure because
it depends on the missing object 'dbo.sp_MScreatedebuginfrastructure'.
The stored procedure will still be created.
Msg 174, Level 15, State 1, Server PL-NTSQL4, Procedure sp_MSdeletecontents, Line 45
The updatelineage function requires 2 arguments.
Anyone got any ideas?
I've tried manually stopping all services before retrying etc.
I've tried both a SQL id and a trusted connection.