Re: Re:SP4 error running replsys.sql

Tech-Archive recommends: Speed Up your PC by fixing your registry



OK, I think I've managed to sort this out by running the service pack
install in debug mode (setupsql.exe k=Dbg) and skipping all of the scripts.
I was then able to start SQL in single user mode (sqlsevr.exe -m) and use
osql to execute each script manually.

With SP3 already installed, the list of scripts setup tried to run was:
1. upgrade.sql
2. replsys.sql
3. replcom.sql
4. repltran.sql
5. replmerg.sql
6. remove_old_msx_accounts.sql
7. sp4_serv_uni.sql
8. 80sp4-tools.sql

With the exception of upgrade.sql, all of the other scripts failed with the
"[DBNETLIB]ConnectionRead (recv())" error when run from the installation
program, but succeeded when run from osql.


"Jasper Smith" <jasper_smith9@xxxxxxxxxxx> wrote in message
news:ODn2ytHWFHA.2520@xxxxxxxxxxxxxxxxxxxxxxx
>I have reported it on our privte newsgroup. I've been doing installs this
>morning on Win2k3SP1 + SQL2000 EE and the only setup failure was when I
>changed the network packet size to 65536. When I did that setup could not
>authenticate my user account because it couldn't even log in to SQL
>(neither could I using QA) but I've not managed to ever get it to fail on
>replsys.sql
>
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org


.



Relevant Pages

  • Re: Install Northwind SQL Database?
    ... Eastern Time as I am located in Pennsylvania. ... I tried to install some components and the setup told me they were ... I tried running the scripts using osql and got the error ... It would also be helpful to know what version of SQL Server you're using. ...
    (microsoft.public.sqlserver.setup)
  • Re: Scriptable dynamic forms applications
    ... Also, keep in mind that SQL Server, NexusDB or Oracle scripting are targeted at 'normal' developpers. ... if .NET "scripts" would not allocate anything major. ... MSN Messenger is the first thing I kick out of windows after install, don't plan of ever installing it back;) ...
    (borland.public.delphi.non-technical)
  • Re: Install Northwind SQL Database?
    ... C:\SQL Server 2000 Sample Databases are: ReadMe SQL Sample Db Scripts, ... LogTransaction, SQL Server Database Primary File for Northwind, instPubs SQL ... practice install on a virtual machine. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multiple Questions
    ... adding to the local administrators group is giving ... Login scripts - I've a bunch of various apps I need installed on ... Assigning to a user will install the app upon logon. ...
    (microsoft.public.win2000.active_directory)
  • Re: Multiple Questions
    ... adding to the local administrators group is giving ... Login scripts - I've a bunch of various apps I need installed on ... Assigning to a user will install the app upon logon. ...
    (microsoft.public.win2000.general)