Error in SQL startup

Hi guys,

I have an SQL Server 2000 installed on a Windows server 2003. Yesterday, i restart my server and before login to the server the following message poped-up:

"Your SQL Server installation is either corrupt or has been tampered with (unable to load SQLBOOT.DLL). Please uninstall, then re-run setup to correct this problem"

Any ideas what this error is or why occurred?
Any help will be appreciated.

have u checked the sqllog and application log.. post the error from Log. its looks like the REGISTRY/system drive got corrupted/ or master file corrupted... what all are the backup u have. Do u have system dbs backups ?...

Madhu

|||

There are no errors in the event viewer regarding the error i tild you above. There is only the 19012 error which has to do something with the TCP port.

Any other ideas what this error should be?

|||Please post the sql log here. It would help us help you pinpoint the problem. The sqlboot error simply means the service doesn't get all the resources it needs to start up. A re-install typically will fix this.|||

generally this might be the log file path. C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG . Open the ERRORLOG file and paste the contents here

Madhu

Error in sql log when restarting SQL server

Whenever we restart sql server the following error appears:
2005-12-20 12:34:22.28 server Attempting to initialize Distributed
Transaction Coordinator.
2005-12-20 12:34:22.31 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
When I check the MSDTC service in the SQL service manager to see if is
running - the service says it is running. Do I still have anything to worry
about?
We are running SL server 2000 sp3a.
thanks
MeenalHi
Checking other posts it seems that this is a warning telling you that MSDTC
has not started at the time and most people seem to ignore it. You could mak
e
the SQL Service dependent on MSDTC although this is not a usual condition an
d
will slow down the bootup process.
John
"Meenal Dhody" wrote:

> Whenever we restart sql server the following error appears:
> 2005-12-20 12:34:22.28 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2005-12-20 12:34:22.31 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> When I check the MSDTC service in the SQL service manager to see if is
> running - the service says it is running. Do I still have anything to wor
ry
> about?
> We are running SL server 2000 sp3a.
> thanks
> Meenal
>
>|||Many thanks
Meenal
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ECF7845A-79A0-4D8E-91EC-0D367454B336@.microsoft.com...
> Hi
> Checking other posts it seems that this is a warning telling you that
MSDTC
> has not started at the time and most people seem to ignore it. You could
make
> the SQL Service dependent on MSDTC although this is not a usual condition
and[vbcol=seagreen]
> will slow down the bootup process.
> John
> "Meenal Dhody" wrote:
>
worry[vbcol=seagreen]|||Meenal Dhody Wrote:
> Many thanks
> Meenal
> "John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote
THis won't cause any issue because SQL server starts earlier than DTC.
This happens due to chain process, that DTC depends on RPC and it takes
long time.
If you able to access SQL server once it is released for use then ok.
Else you can add depend on in the registry of regedt32 for sql server
Cheers,
muthu
Muthu
---
Muthu's Profile: http://www.dbtalk.net/m370
View this thread: http://www.dbtalk.net/t302909

Error in sql log when restarting SQL server

Whenever we restart sql server the following error appears:
2005-12-20 12:34:22.28 server Attempting to initialize Distributed
Transaction Coordinator.
2005-12-20 12:34:22.31 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
When I check the MSDTC service in the SQL service manager to see if is
running - the service says it is running. Do I still have anything to worry
about?
We are running SL server 2000 sp3a.
thanks
MeenalHi
Checking other posts it seems that this is a warning telling you that MSDTC
has not started at the time and most people seem to ignore it. You could make
the SQL Service dependent on MSDTC although this is not a usual condition and
will slow down the bootup process.
John
"Meenal Dhody" wrote:
> Whenever we restart sql server the following error appears:
> 2005-12-20 12:34:22.28 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2005-12-20 12:34:22.31 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> When I check the MSDTC service in the SQL service manager to see if is
> running - the service says it is running. Do I still have anything to worry
> about?
> We are running SL server 2000 sp3a.
> thanks
> Meenal
>
>|||Many thanks
Meenal
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ECF7845A-79A0-4D8E-91EC-0D367454B336@.microsoft.com...
> Hi
> Checking other posts it seems that this is a warning telling you that
MSDTC
> has not started at the time and most people seem to ignore it. You could
make
> the SQL Service dependent on MSDTC although this is not a usual condition
and
> will slow down the bootup process.
> John
> "Meenal Dhody" wrote:
> > Whenever we restart sql server the following error appears:
> >
> > 2005-12-20 12:34:22.28 server Attempting to initialize Distributed
> > Transaction Coordinator.
> > 2005-12-20 12:34:22.31 server Failed to obtain
> > TransactionDispenserInterface: Result Code = 0x8004d01b
> >
> > When I check the MSDTC service in the SQL service manager to see if is
> > running - the service says it is running. Do I still have anything to
worry
> > about?
> > We are running SL server 2000 sp3a.
> >
> > thanks
> > Meenal
> >
> >
> >|||Meenal Dhody Wrote:
> Many thanks
> Meenal
> "John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote
THis won't cause any issue because SQL server starts earlier than DTC
This happens due to chain process, that DTC depends on RPC and it take
long time.
If you able to access SQL server once it is released for use then ok
Else you can add depend on in the registry of regedt32 for sql server
Cheers,
muth
--
Muth
----
Muthu's Profile: http://www.dbtalk.net/m37
View this thread: http://www.dbtalk.net/t30290