Can't start SQL Sever 2000 after sysprep.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: zenophile (zenophile_at_ntlworld.com)
Date: 01/27/05 

Date: Thu, 27 Jan 2005 13:57:11 GMT

Hello,

After applying sysprep to this machine (Win XP pro SP2) I can't
start SQL Sever 2000 SP3a (Personal).

The computer doesn't have a domain. I initially started it again
(after sysprep) with the wrong workgroup but that has now been
corrected.

Although I can see the service in the system tray I can't start
it. Opening Query Analyser and clicking registered servers shows
one server there (which is on another machine on the network)
BUT NOT the server I want (on the local machine). The machine
name didn't change when applying sysprep.

I've checked the network protocols and they're all there. The
software is there. It's trying to start but it won't.

Nothing much changed during after apply sysprep except I made
the following change from the Sysprep.inf file that setupmgr.exe
generated:

[SetupMgr]
    DistShare=whistlerdist

in place of

[SetupMgr]
    DistShare=windist

Could that be causing the problem?

I also included the following 2 entries:

[SysPrep]
    BuildMassStorageSection=Yes

[SysprepMassStorage]

How do I check the "registration properties" of my SQL Server?

Would I be better of by uninstalling it and reinstalling?

Appendix - error msgs:
=====================
A connection could not be established to Pentium3\SQL2K

Reason: SQL Server does not exist or access denied.

ConnectionOpen (Connect())..

Please verify SQL Server is running and check your SQL Server
registration properties (by right-clicking on the Pentium3\SQL2K
node) and try again.

=====================

Unable to connect to server Pentium3\SQL2K

Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not
exist or access denied.

=====================

Relevant Pages

  • Cant start SQL Sever 2000 after sysprep.
    ... After applying sysprep to this machine I can't ... BUT NOT the server I want. ... SQL Server does not exist or access denied. ...
    (microsoft.public.sqlserver.setup)
  • Sysprepd SQL 2000 Install issues
    ... I saw several notes about SQL7 issues and sysprep, ... for SQL 2000 has a comment that implies this should work. ... Deploying SQL Server After Initial Installation ...
    (microsoft.public.sqlserver.setup)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)