Corrupt SQL Server!!!

[CrystalVis]

I have SQL 2K Dev Ed installed on my laptop. The IT person decided to rename my laptop. Now everytime I boot up, I revecie this message:

"your sql server installation is either corrupt or has been tampered with (unable to load SQLBOOT.DLL)."

I cannot start the local server on my laptop. I have already tried to uninstall and re-install multiple times. But it doesn't fix the problem. Can you please help. Your help/suggestion is greatly appreciated.

 

[mrdenny]

What errors do you get in the error log? How about the event log?

Denny

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

 

[CrystalVis]

Thanks for your respond. here is the content from the error log file.

2004-02-27 07:11:50.41 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 1)

2004-02-27 07:11:50.41 server Copyright (C) 1988-2000 Microsoft Corporation.
2004-02-27 07:11:50.41 server All rights reserved.
2004-02-27 07:11:50.41 server Server Process ID is 688.
2004-02-27 07:11:50.41 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$TPA_Mercury_XP\log\ERRORLOG'.
2004-02-27 07:11:50.48 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2004-02-27 07:11:50.84 server SQL Server configured for thread mode processing.
2004-02-27 07:11:50.88 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2004-02-27 07:11:50.95 server Attempting to initialize Distributed Transaction Coordinator.
2004-02-27 07:11:51.00 server Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
2004-02-27 07:11:51.04 spid3 Starting up database 'master'.
2004-02-27 07:11:52.72 server Using 'SSNETLIB.DLL' version '8.0.194'.
2004-02-27 07:11:52.72 spid5 Starting up database 'model'.
2004-02-27 07:11:52.86 spid3 Server name is 'TPA_Mercury_XP\TPA_Mercury_XP'.
2004-02-27 07:11:52.89 spid8 Starting up database 'msdb'.
2004-02-27 07:11:52.89 spid9 Starting up database 'pubs'.
2004-02-27 07:11:52.89 spid10 Starting up database 'Northwind'.
2004-02-27 07:11:53.10 server SQL server listening on TCP, Shared Memory, Named Pipes.
2004-02-27 07:11:53.10 server SQL server listening on 190.160.1.101:3010, 127.0.0.1:3010.
2004-02-27 07:11:53.10 server SQL Server is ready for client connections
2004-02-27 07:11:54.10 spid5 Clearing tempdb database.
2004-02-27 07:11:58.23 spid5 Starting up database 'tempdb'.
2004-02-27 07:11:59.28 spid3 Recovery complete.
2004-02-27 09:31:49.97 server SQL Server terminating because of system shutdown.
2004-02-27 09:31:50.01 server LogEvent: Failed to report the current event. Operating system error = 31(A device attached to the system is not functioning.).
2004-02-27 09:31:54.69 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

 

[CrystalVis]

no expert in this forum can help???

 

[SQLBill]

Do a Search and see if you can find SQLBOOT.DLL on your computer.

It should be in Program Files\Microsoft SQL Server\MSSQL\Binn

It's a 33KB file.

If you find it and it's not at that location, move it to there.

If you can't find it, explore your installation disk, and copy it to it's proper location.

-SQLBill

 

[CrystalVis]

thanks for your suggestion. the SQLBOOT.DLL is in the correct location.

 

[SQLBill]

Have you entered this error into Microsoft's Tech help or GOOGLE (or some other search)?

Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b

-SQLBill

 

[SQLBill]

If you haven't searched on that error, here is what Microsoft says:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_2_4egj.asp

-SQLBill

 

[SQLBill]

Here's another:

http://dbforums.com/arch/175/2003/3/736033

and:

http://sqlpass.org/Forums/messageview.cfm?catid=359&threadid=7272

and:

http://www.chriskempster.com/tipsandhints.html

All seem to point to MSDTC problems (starting at the wrong time or not at all)

-SQLBill