Re: Upgrading from SQL 7 to SQL 2000 - Setup Fails

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Casey Vanlandingham (cvanlan_at_no.spam.iastate.edu)
Date: 02/09/04 

Date: Mon, 9 Feb 2004 09:12:25 -0600

This is a known problem

The problem lies within the setup.inf file (I believe that is its name).

You have to copy the entire SQL 2000 CD to the server. Then replace the
setup.inf file that you download from Microsoft. Then run setup. It should
work properly. (We had this same issue).

"Nate" <nbattinich@technasoft.com> wrote in message
news:b512454a.0402061148.118072b1@posting.google.com...
> I am having the same problem upgrading our servers that has been
> posted several times on this group.
>
> FIX: Upgrade from SQL Server 7.0 May Abort with Messages.sql and You
> Cannot Connect to SQL Server
>
> Error Running Script Message.sql(1)
>
> The install fails when it tries to run scripts. The databases are
> upgraded to 2000 version and I can start sql server service - but the
> install does not complete corectly.
>
> I have tried different versions of SQL 2000 - The only KB article for
> a fix gives a bogus ftp: location. I find it hard to believe that
> there is not a work around for this - I know I am not the only person
> upgrading existing sql 7 to sql 2000. Whe have several servers and
> installing from scratch and setting up all of the dbs is out of the
> question.
>
> Is the s80305i.exe file the only fix? If so why does micrsoft not have
> it readily available or a patched version that can be dowloaded from a
> MSDN subscriber download area?
>
> Thanks

Relevant Pages

  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)
  • Re: Trying to Move Group - SQL Instance Wont Start
    ... You can do a maintenance install and add the new nodes. ... "maintaining a failover cluster" for recovery from failure scenario 1. ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... While attempting to install SP4, it comes up immediately after I ... to be on one of the nodes that can bring SQL Server online and apply SP3a, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Any help here???
    ... Well, for starters, I believe MDAC is unnecessary for .NET applications - as ... ADO.NET has its own SQL Server provider for data access. ... > trust me - all that's been done here was to install SP2 or upgrade of XP ...
    (microsoft.public.dotnet.framework.aspnet)