MSSQLServerADHelper Service Error on Reboot

I am running SQL Server 2000 sp 4 on Win2K Server sp 4.
Recently, I started getting an MSSQLServerADHelper service error. I can't
rely pin it on anything, other than I had a big database with 2 tables (7 and
20 million records respectively). I ran out of disk space trying to index
one of the tables.
Ultimately, I detached the database, because it was too much for my system.
Since then I have completely removed then reinstalled SQL Server and I still
get the following errors. The MSSQLServerADHelper is set to automatic, which
I believe is the correct state since is supposedly launched as needed. I
have done some research and cannot track down an answer. Any ideas?
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7024
Date:6/26/2005
Time:1:54:11 AM
User:N/A
Computer:MERLOT
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572.
Event Type:Error
Event Source:MSSQLServerADHelper
Event Category:None
Event ID:100
Date:6/26/2005
Time:1:54:11 AM
User:N/A
Computer:MERLOT
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17055
Date:6/26/2005
Time:2:33:04 PM
User:N/A
Computer:MERLOT
Description:
19012 :
SuperSocket Info: Bind failed on TCP port 1433.
Data:
0000: 44 4a 00 00 10 00 00 00 DJ.....
0008: 07 00 00 00 4d 00 45 00 ...M.E.
0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
0018: 00 00 00 00 00 00 .....
The MSSQLServerADHelper service should be set to manual. SQL
Server will start and stop the service itself when needed.
-Sue
On Sun, 26 Jun 2005 20:06:01 -0700, Jed
<Jed@.discussions.microsoft.com> wrote:

>I am running SQL Server 2000 sp 4 on Win2K Server sp 4.
>Recently, I started getting an MSSQLServerADHelper service error. I can't
>rely pin it on anything, other than I had a big database with 2 tables (7 and
>20 million records respectively). I ran out of disk space trying to index
>one of the tables.
>Ultimately, I detached the database, because it was too much for my system.
>Since then I have completely removed then reinstalled SQL Server and I still
>get the following errors. The MSSQLServerADHelper is set to automatic, which
>I believe is the correct state since is supposedly launched as needed. I
>have done some research and cannot track down an answer. Any ideas?
>Event Type:Error
>Event Source:Service Control Manager
>Event Category:None
>Event ID:7024
>Date:6/26/2005
>Time:1:54:11 AM
>User:N/A
>Computer:MERLOT
>Description:
>The MSSQLServerADHelper service terminated with service-specific error
>3221225572.
>Event Type:Error
>Event Source:MSSQLServerADHelper
>Event Category:None
>Event ID:100
>Date:6/26/2005
>Time:1:54:11 AM
>User:N/A
>Computer:MERLOT
>Description:
>'0' is an invalid number of start up parameters. This service takes two
>start up parameters.
>Event Type:Error
>Event Source:MSSQLSERVER
>Event Category:(2)
>Event ID:17055
>Date:6/26/2005
>Time:2:33:04 PM
>User:N/A
>Computer:MERLOT
>Description:
>19012 :
>SuperSocket Info: Bind failed on TCP port 1433.
>Data:
>0000: 44 4a 00 00 10 00 00 00 DJ.....
>0008: 07 00 00 00 4d 00 45 00 ...M.E.
>0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
>0018: 00 00 00 00 00 00 .....

MSSQLServerADHelper Service Error on Reboot

I am running SQL Server 2000 sp 4 on Win2K Server sp 4.
Recently, I started getting an MSSQLServerADHelper service error. I can't
rely pin it on anything, other than I had a big database with 2 tables (7 an
d
20 million records respectively). I ran out of disk space trying to index
one of the tables.
Ultimately, I detached the database, because it was too much for my system.
Since then I have completely removed then reinstalled SQL Server and I still
get the following errors. The MSSQLServerADHelper is set to automatic, whic
h
I believe is the correct state since is supposedly launched as needed. I
have done some research and cannot track down an answer. Any ideas?
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 6/26/2005
Time: 1:54:11 AM
User: N/A
Computer: MERLOT
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572.
Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date: 6/26/2005
Time: 1:54:11 AM
User: N/A
Computer: MERLOT
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 6/26/2005
Time: 2:33:04 PM
User: N/A
Computer: MERLOT
Description:
19012 :
SuperSocket Info: Bind failed on TCP port 1433.
Data:
0000: 44 4a 00 00 10 00 00 00 DJ.....
0008: 07 00 00 00 4d 00 45 00 ...M.E.
0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
0018: 00 00 00 00 00 00 .....The MSSQLServerADHelper service should be set to manual. SQL
Server will start and stop the service itself when needed.
-Sue
On Sun, 26 Jun 2005 20:06:01 -0700, Jed
<Jed@.discussions.microsoft.com> wrote:

>I am running SQL Server 2000 sp 4 on Win2K Server sp 4.
>Recently, I started getting an MSSQLServerADHelper service error. I can't
>rely pin it on anything, other than I had a big database with 2 tables (7 a
nd
>20 million records respectively). I ran out of disk space trying to index
>one of the tables.
>Ultimately, I detached the database, because it was too much for my system.
>Since then I have completely removed then reinstalled SQL Server and I stil
l
>get the following errors. The MSSQLServerADHelper is set to automatic, whi
ch
>I believe is the correct state since is supposedly launched as needed. I
>have done some research and cannot track down an answer. Any ideas?
>Event Type: Error
>Event Source: Service Control Manager
>Event Category: None
>Event ID: 7024
>Date: 6/26/2005
>Time: 1:54:11 AM
>User: N/A
>Computer: MERLOT
>Description:
>The MSSQLServerADHelper service terminated with service-specific error
>3221225572.
>Event Type: Error
>Event Source: MSSQLServerADHelper
>Event Category: None
>Event ID: 100
>Date: 6/26/2005
>Time: 1:54:11 AM
>User: N/A
>Computer: MERLOT
>Description:
>'0' is an invalid number of start up parameters. This service takes two
>start up parameters.
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17055
>Date: 6/26/2005
>Time: 2:33:04 PM
>User: N/A
>Computer: MERLOT
>Description:
>19012 :
>SuperSocket Info: Bind failed on TCP port 1433.
>Data:
>0000: 44 4a 00 00 10 00 00 00 DJ.....
>0008: 07 00 00 00 4d 00 45 00 ...M.E.
>0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
>0018: 00 00 00 00 00 00 .....

MSSQLServerADHelper Service Error on Reboot

I am running SQL Server 2000 sp 4 on Win2K Server sp 4.
Recently, I started getting an MSSQLServerADHelper service error. I can't
rely pin it on anything, other than I had a big database with 2 tables (7 and
20 million records respectively). I ran out of disk space trying to index
one of the tables.
Ultimately, I detached the database, because it was too much for my system.
Since then I have completely removed then reinstalled SQL Server and I still
get the following errors. The MSSQLServerADHelper is set to automatic, which
I believe is the correct state since is supposedly launched as needed. I
have done some research and cannot track down an answer. Any ideas?
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 6/26/2005
Time: 1:54:11 AM
User: N/A
Computer: MERLOT
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572.
Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date: 6/26/2005
Time: 1:54:11 AM
User: N/A
Computer: MERLOT
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 6/26/2005
Time: 2:33:04 PM
User: N/A
Computer: MERLOT
Description:
19012 :
SuperSocket Info: Bind failed on TCP port 1433.
Data:
0000: 44 4a 00 00 10 00 00 00 DJ.....
0008: 07 00 00 00 4d 00 45 00 ...M.E.
0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
0018: 00 00 00 00 00 00 .....The MSSQLServerADHelper service should be set to manual. SQL
Server will start and stop the service itself when needed.
-Sue
On Sun, 26 Jun 2005 20:06:01 -0700, Jed
<Jed@.discussions.microsoft.com> wrote:
>I am running SQL Server 2000 sp 4 on Win2K Server sp 4.
>Recently, I started getting an MSSQLServerADHelper service error. I can't
>rely pin it on anything, other than I had a big database with 2 tables (7 and
>20 million records respectively). I ran out of disk space trying to index
>one of the tables.
>Ultimately, I detached the database, because it was too much for my system.
>Since then I have completely removed then reinstalled SQL Server and I still
>get the following errors. The MSSQLServerADHelper is set to automatic, which
>I believe is the correct state since is supposedly launched as needed. I
>have done some research and cannot track down an answer. Any ideas?
>Event Type: Error
>Event Source: Service Control Manager
>Event Category: None
>Event ID: 7024
>Date: 6/26/2005
>Time: 1:54:11 AM
>User: N/A
>Computer: MERLOT
>Description:
>The MSSQLServerADHelper service terminated with service-specific error
>3221225572.
>Event Type: Error
>Event Source: MSSQLServerADHelper
>Event Category: None
>Event ID: 100
>Date: 6/26/2005
>Time: 1:54:11 AM
>User: N/A
>Computer: MERLOT
>Description:
>'0' is an invalid number of start up parameters. This service takes two
>start up parameters.
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17055
>Date: 6/26/2005
>Time: 2:33:04 PM
>User: N/A
>Computer: MERLOT
>Description:
>19012 :
>SuperSocket Info: Bind failed on TCP port 1433.
>Data:
>0000: 44 4a 00 00 10 00 00 00 DJ.....
>0008: 07 00 00 00 4d 00 45 00 ...M.E.
>0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
>0018: 00 00 00 00 00 00 .....

MSSQLSERVER service hangs on loading DTC

Hi All,
MSSSQLSERVER service is hanging for ever after auto reboot.
it stops at DTC loading :
SQL Server terminating because of system shutdown.
SQL Server is starting at priority class 'normal'(4 CPUs detected).
SQL Server configured for thread mode processing.
Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
Attempting to initialize Distributed Transaction Coordinator.
.........
..............
DTC service is disabled and running under local system account.
Sql services are running under domain admin account.
We are starting it manually every time this occurs.
the version is
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
There is below DCOM error in the eveny log at the same time.Is this causing
the problem?
DCOM got error "The service cannot be started, either because it is disabled
or because it has no enabled devices associated with it. " attempting to
start the service EventSystem with arguments "" in order to run the server:
{1BE1F766-5536-11D1-B726-00C04FB926AF}
Can any one shed some light on it?
Thanks,
Suchi
Some more info:
Start up modes are as below:
Mssqlserver --manual
SQLagent--Manual
DTC --manual
Disabled auto-startup of the 3 services from within EM.
Thanks,
Suchi
"Suchi" wrote:

> Hi All,
> MSSSQLSERVER service is hanging for ever after auto reboot.
> it stops at DTC loading :
> SQL Server terminating because of system shutdown.
> SQL Server is starting at priority class 'normal'(4 CPUs detected).
> SQL Server configured for thread mode processing.
> Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
> Attempting to initialize Distributed Transaction Coordinator.
> ........
> .............
> DTC service is disabled and running under local system account.
> Sql services are running under domain admin account.
> We are starting it manually every time this occurs.
> the version is
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
> There is below DCOM error in the eveny log at the same time.Is this causing
> the problem?
> DCOM got error "The service cannot be started, either because it is disabled
> or because it has no enabled devices associated with it. " attempting to
> start the service EventSystem with arguments "" in order to run the server:
> {1BE1F766-5536-11D1-B726-00C04FB926AF}
> Can any one shed some light on it?
> Thanks,
> Suchi
>
|||Did you try reinstalling DTC?
I dont' think DCOM alert has something to do with it...not sure doh.

MSSQLSERVER service hangs on loading DTC

Hi All,
MSSSQLSERVER service is hanging for ever after auto reboot.
it stops at DTC loading :
SQL Server terminating because of system shutdown.
SQL Server is starting at priority class 'normal'(4 CPUs detected).
SQL Server configured for thread mode processing.
Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
Attempting to initialize Distributed Transaction Coordinator.
........
.............
DTC service is disabled and running under local system account.
Sql services are running under domain admin account.
We are starting it manually every time this occurs.
the version is
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
There is below DCOM error in the eveny log at the same time.Is this causing
the problem?
DCOM got error "The service cannot be started, either because it is disabled
or because it has no enabled devices associated with it. " attempting to
start the service EventSystem with arguments "" in order to run the server:
{1BE1F766-5536-11D1-B726-00C04FB926AF}
Can any one shed some light on it?
Thanks,
SuchiSome more info:
Start up modes are as below:
Mssqlserver --manual
SQLagent--Manual
DTC --manual
Disabled auto-startup of the 3 services from within EM.
Thanks,
Suchi
"Suchi" wrote:
> Hi All,
> MSSSQLSERVER service is hanging for ever after auto reboot.
> it stops at DTC loading :
> SQL Server terminating because of system shutdown.
> SQL Server is starting at priority class 'normal'(4 CPUs detected).
> SQL Server configured for thread mode processing.
> Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
> Attempting to initialize Distributed Transaction Coordinator.
> ........
> .............
> DTC service is disabled and running under local system account.
> Sql services are running under domain admin account.
> We are starting it manually every time this occurs.
> the version is
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
> There is below DCOM error in the eveny log at the same time.Is this causing
> the problem?
> DCOM got error "The service cannot be started, either because it is disabled
> or because it has no enabled devices associated with it. " attempting to
> start the service EventSystem with arguments "" in order to run the server:
> {1BE1F766-5536-11D1-B726-00C04FB926AF}
> Can any one shed some light on it?
> Thanks,
> Suchi
>|||Did you try reinstalling DTC?
I dont' think DCOM alert has something to do with it...not sure doh.

MSSQLSERVER service hangs on loading DTC

Hi All,
MSSSQLSERVER service is hanging for ever after auto reboot.
it stops at DTC loading :
SQL Server terminating because of system shutdown.
SQL Server is starting at priority class 'normal'(4 CPUs detected).
SQL Server configured for thread mode processing.
Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner
Blocks.
Attempting to initialize Distributed Transaction Coordinator.
........
.............
DTC service is disabled and running under local system account.
Sql services are running under domain admin account.
We are starting it manually every time this occurs.
the version is
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
There is below DCOM error in the eveny log at the same time.Is this causing
the problem?
DCOM got error "The service cannot be started, either because it is disabled
or because it has no enabled devices associated with it. " attempting to
start the service EventSystem with arguments "" in order to run the server:
{1BE1F766-5536-11D1-B726-00C04FB926AF}
Can any one shed some light on it?
Thanks,
SuchiSome more info:
Start up modes are as below:
Mssqlserver --manual
SQLagent--Manual
DTC --manual
Disabled auto-startup of the 3 services from within EM.
Thanks,
Suchi
"Suchi" wrote:

> Hi All,
> MSSSQLSERVER service is hanging for ever after auto reboot.
> it stops at DTC loading :
> SQL Server terminating because of system shutdown.
> SQL Server is starting at priority class 'normal'(4 CPUs detected).
> SQL Server configured for thread mode processing.
> Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Own
er Blocks.
> Attempting to initialize Distributed Transaction Coordinator.
> ........
> .............
> DTC service is disabled and running under local system account.
> Sql services are running under domain admin account.
> We are starting it manually every time this occurs.
> the version is
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
> There is below DCOM error in the eveny log at the same time.Is this causin
g
> the problem?
> DCOM got error "The service cannot be started, either because it is disabl
ed
> or because it has no enabled devices associated with it. " attempting to
> start the service EventSystem with arguments "" in order to run the server
:
> {1BE1F766-5536-11D1-B726-00C04FB926AF}
> Can any one shed some light on it?
> Thanks,
> Suchi
>|||Did you try reinstalling DTC?
I dont' think DCOM alert has something to do with it...not sure doh.