Wednesday, March 21, 2012

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 .....

No comments:

Post a Comment