MSSQLServerADHelper is problem?

MSSQLServerADHelper isn't running and we can't get it to
start. System Event Log says "The MSSQLServerADHelper
service terminated with service-specific error 3221225572."
Any clues at all how to fix?

>--Original Message--
>That's SQL Server 2000 (sorry!) and Windows (Server)
>2000... it's almost like SQL isn't reading from or
>synchronizing with Active Directory properly, but we can
>find no other indicator that there is a problem.
>Again, any help is greatly appreciated!
>
>login
I
>a
the
>.
>That's normal behavior. You can't start the service
manually. It runs when requested to by SQL Server service or
Analysis Server service and then stops running when it's
completed it's work.
-Sue
On Thu, 25 Mar 2004 12:27:49 -0800, "Sandy Mach"
<anonymous@.discussions.microsoft.com> wrote:
>MSSQLServerADHelper isn't running and we can't get it to
>start. System Event Log says "The MSSQLServerADHelper
>service terminated with service-specific error 3221225572."
>Any clues at all how to fix?
>
>I
>the|||Well I was just trying to find something... is there any
way to see if it's working properly when it's supposed to
be working? My gut tells me this problem has to do with
AD somehow...
Can you think of any other options or ways to fix?

>--Original Message--
>That's normal behavior. You can't start the service
>manually. It runs when requested to by SQL Server service
or
>Analysis Server service and then stops running when it's
>completed it's work.
>-Sue
>On Thu, 25 Mar 2004 12:27:49 -0800, "Sandy Mach"
><anonymous@.discussions.microsoft.com> wrote:
>
3221225572."
can
if
in
adding
and
won't
then
>.
>|||Try revoking the login and then re-add it and see if you can
add the login as a database user.
Is the a problem for all logins or just one or a few? Is it
a problem with trying to add them to any database or just
one specific database?
-Sue
On Thu, 25 Mar 2004 13:31:55 -0800, "Sandy Mach"
<anonymous@.discussions.microsoft.com> wrote:
>Well I was just trying to find something... is there any
>way to see if it's working properly when it's supposed to
>be working? My gut tells me this problem has to do with
>AD somehow...
>Can you think of any other options or ways to fix?
>
>or
>3221225572."
>can
>if
>in
>adding
>and
>won't
>then|||Well, that did the job, but now I have to re-set the
group's permissions on each db, some of which contain over
200 tables... yikes. I guess I could look at the bright
side--I should only have to do this once!
Thanks for your help Sue.
Sandy

>--Original Message--
>Try revoking the login and then re-add it and see if you
can
>add the login as a database user.
>Is the a problem for all logins or just one or a few? Is
it
>a problem with trying to add them to any database or just
>one specific database?
>-Sue
>On Thu, 25 Mar 2004 13:31:55 -0800, "Sandy Mach"
><anonymous@.discussions.microsoft.com> wrote:
>
to
service
to
but
error
looked
use|||Your welcome...glad it's working now and thanks for posting
back.
-Sue
On Thu, 25 Mar 2004 14:22:19 -0800, "Sandy Mach"
<anonymous@.discussions.microsoft.com> wrote:
>Well, that did the job, but now I have to re-set the
>group's permissions on each db, some of which contain over
>200 tables... yikes. I guess I could look at the bright
>side--I should only have to do this once!
>Thanks for your help Sue.
>Sandy
>
>can
>it
>to
>service
>to
>but
>error
>looked
>use

MSSQLSERVER Service cannot start [SQL 2000]

Hi All,
MSSQLSERVER Service is not started, when I try to start it, it tries to
start then it remains not started.
What are the possible causes of this issue?
What are the possible solutions other than reinstalling the SQL software?
Thank you.
Bishoy
Take a look at the SQL Server error log for the cause. The default location
for the logs is folder C:\Program Files\Microsoft SQL Server\MSSQL\LOG. The
most current file is ERRORLOG with no extention. There may also be related
messages in the event log.
Hope this helps.
Dan Guzman
SQL Server MVP
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:04183556-AC55-4230-B404-69D2F13D1A62@.microsoft.com...
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy
|||There are many possible causes, open a command window and navigate to where
the binary is and then issue the following
sqlservr -Con
This will start sql server up in a console and you can see the error
message.
You can find the Sql 2000 binary at
C:\Program Files\Microsoft SQL Server\MSSQL$InstanceName\Binn
or
C:\Program Files\Microsoft SQL Server\MSSQL\Binn
Your best bet for SQL 2005 is to check the event log or open up the error
log (it is plain text) and you can find it at
C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\LOG
You can also start it at the command prompt like this
C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\binn\sqlservr.exe -m -f
where x is your instance number
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:04183556-AC55-4230-B404-69D2F13D1A62@.microsoft.com...
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy
|||Hi,
Chk the Error log files and event viewer log files,
Chk for password if password is changed for service log on account.
Amol Lembhe
"SW" wrote:

> Bishoy napisa?(a):
> Hi chceck server service
> regards
> SW
>

MSSQLSERVER Service cannot start [SQL 2000]

Hi All,
MSSQLSERVER Service is not started, when I try to start it, it tries to
start then it remains not started.
What are the possible causes of this issue?
What are the possible solutions other than reinstalling the SQL software?
Thank you.
BishoyTake a look at the SQL Server error log for the cause. The default location
for the logs is folder C:\Program Files\Microsoft SQL Server\MSSQL\LOG. The
most current file is ERRORLOG with no extention. There may also be related
messages in the event log.
Hope this helps.
Dan Guzman
SQL Server MVP
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:04183556-AC55-4230-B404-69D2F13D1A62@.microsoft.com...
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy|||There are many possible causes, open a command window and navigate to where
the binary is and then issue the following
sqlservr -Con
This will start sql server up in a console and you can see the error
message.
You can find the Sql 2000 binary at
C:\Program Files\Microsoft SQL Server\MSSQL$InstanceName\Binn
or
C:\Program Files\Microsoft SQL Server\MSSQL\Binn
Your best bet for SQL 2005 is to check the event log or open up the error
log (it is plain text) and you can find it at
C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\LOG
You can also start it at the command prompt like this
C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\binn\sqlservr.exe -m -f
where x is your instance number
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:04183556-AC55-4230-B404-69D2F13D1A62@.microsoft.com...
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy|||Bishoy napisa?(a):
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy
Hi chceck server service
regards
SW|||Hi,
Chk the Error log files and event viewer log files,
Chk for password if password is changed for service log on account.
Amol Lembhe
"SW" wrote:

> Bishoy napisa?(a):
> Hi chceck server service
> regards
> SW
>