starting SQLServer 2000 "network path was not found"

[oakgrove]

Hi,
I have sqlserver 2000 running on winxp sp2. I recently had the HD changed to a larger drive all programs and files seemed to have transfered over ok. I just installed VStudio 2005 which put a copy of sqlexpress on the machine.

Now when I try to start sqlserver2000 with the name of the machine I get:
"An error 3 - (The system cannot find the path specified.) Occrued while performing this service operation on the MSSQLServer service."

When I try to start it as local I get just "network path was not found"

When I look at MSSQLSERVER Properties (Local Computer)
the path to executable is:
"C:\PROGRA~1\MICROS~4\MSSQL\binn\sqlservr.exe"
When I use windows explorer to look at:
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn"
I do find "sqlservr.exe"
I find 3 entries at this registry hive
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\Parameters"
"-dc:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf"
"-ec:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG"
"-dc:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf"

I have removed the -d and -e from the beginning of each value.

I have also set the "log on as" to the xp current log on.
I have rebooted and logged on with the same user.

Still can't start SQLserver 2000

What am I missing? All help appreciated.





Oakgrove Computer Grouper
Lansing, MI

 

[mrdenny]

First put the -d and -e back in front of the values. They are there for a reason. What errors are in the errorlog?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[oakgrove]

-d and -e replaced
Error logs?
Event Viewer/System shows
1. Sqlexpress was sucessfully sent a start control
2. sqlexpress service entered the stopped state
3. sqlexpress service terminated with service-specif error 17058
4. The MSSQLSERVER service failed to start due to the following error:
The system cannot find the path specified.

Hope this tells you something. I'm beyond my knowledge level.
Thanks for your help

Oakgrove Computer Grouper
Lansing, MI

 

[mrdenny]

Look in the C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG file. Please post the contents.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[oakgrove]

Well thanks for trying to help. I gave up and uninstalled and the reinstalled so I can start work again.
For what it's worth here is the contents of the oldest log but I think it is after I reinstalled

2006-07-21 10:01:50.47 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

2006-07-21 10:01:50.49 server Copyright (C) 1988-2000 Microsoft Corporation.
2006-07-21 10:01:50.49 server All rights reserved.
2006-07-21 10:01:50.49 server Server Process ID is 2088.
2006-07-21 10:01:50.49 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2006-07-21 10:01:50.54 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2006-07-21 10:01:50.91 server SQL Server configured for thread mode processing.
2006-07-21 10:01:50.93 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2006-07-21 10:01:50.95 server Attempting to initialize Distributed Transaction Coordinator.
2006-07-21 10:01:51.23 server Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
2006-07-21 10:01:51.26 spid3 Warning ******************
2006-07-21 10:01:51.26 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2006-07-21 10:01:51.28 spid3 Starting up database 'master'.
2006-07-21 10:01:51.73 spid3 Server name is 'FAXANDBACKUP'.
2006-07-21 10:01:51.73 server Using 'SSNETLIB.DLL' version '8.0.194'.
2006-07-21 10:01:51.73 spid5 Starting up database 'model'.
2006-07-21 10:01:51.81 spid7 Starting up database 'msdb'.
2006-07-21 10:01:51.81 spid8 Starting up database 'pubs'.
2006-07-21 10:01:51.82 spid9 Starting up database 'Northwind'.
2006-07-21 10:01:51.97 server SQL server listening on Shared Memory, Named Pipes.
2006-07-21 10:01:51.97 server SQL Server is ready for client connections
2006-07-21 10:01:52.30 spid5 Clearing tempdb database.
2006-07-21 10:01:53.05 spid5 Starting up database 'tempdb'.
2006-07-21 10:01:53.18 spid3 Recovery complete.
2006-07-21 10:01:53.20 spid3 Warning: override, autoexec procedures skipped.
2006-07-21 10:02:02.24 spid51 Error: 15457, Severity: 0, State: 1
2006-07-21 10:02:02.24 spid51 Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-07-21 10:02:02.51 spid51 Error: 15457, Severity: 0, State: 1
2006-07-21 10:02:02.51 spid51 Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-07-21 10:02:03.36 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.


Oakgrove Computer Grouper
Lansing, MI

 

[mrdenny]

This is from during the install, it's of no helping as to finding out what was wrong before.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com