Re: SP3a was all it took

From: George Hester (hesterloli_at_hotmail.com)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 17:07:34 -0500

Yeah me too. Actually this was the first time I tried 3a. Won't do that
again that's for sure.
I have SP3. So this time I reinstalled SQL 2000. Then I changed my Temp
variables to 8.3 file names. Then cleaned out Temp dirs. Then I installed
SP1. Then cleaned out Temp dirs. Then SP2. Then cleaned out Temp dir.
Then SP3. So all better now.

When I went from SQL 2000 no service pack to SP3a I had 11 sql scripts which
needed to Run. I believe I failed at 8. When I did it the above way I had
only 7 sql scripts which needed to run. 

--
George Hester
_________________________________
"Mark Allison" <marka@no.tinned.meat.mvps.org> wrote in message
news:#4N6bEf1EHA.2192@TK2MSFTNGP14.phx.gbl...
> George,
>
> This "error" is an information message, no error occurred. It is just
> informing you that show advanced options was turned on.
>
> Are you experiencing any problems now that you've reinstalled? Did SP3a
> go on OK second time around? I have installed this hundreds of times and
> rarely encounter problems.
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> George Hester wrote:
> > to waste my installation of SQL 2000.  I installed SQL 2000.  Then I
installed the Service Pack 3a.  Then I failed I think it was 8 in the
install scripts.  That was then end of it.  This in Windows 2000 Advance
Server SP3.  So I uninstalled SQL 2000 and re-installed SQL 2000.  Now I am
back at no Service Pack I believe.  I went in the Enterprise Manager and I
see this in the SQL Server Logs:
> >
> > Configuration option 'show advanced options' changed from 0 to 1. Run
the RECONFIGURE statement to install..
> >
> > and this:
> >
> > Error: 15457, Severity: 0, State: 1
> >
> > I would like to get rid of this error prior to making another attempt to
install SP3a.
> >
> > Any suggestions on what to do here?  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)