question

ramesh 1 avatar image
ramesh 1 asked

sql server 2008

hi team , i am facing a problem, sql server is unable to start,when i have gone through the system error log and sql server error log ,i can see this error **Error: 9954, Severity: 16, State: 1.** how to resolve this,
sql-server-2008error
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
WilliamD avatar image
WilliamD answered
This error comes from the Full Text Search daemon not running (should be part of the error message). Please check that this service is running, then try starting SQL SErver again. It could be that the service account's password has expired, or that the service has crashed and cannot start again, or the service is disabled.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ramesh 1 avatar image ramesh 1 commented ·
sqlserver , agent services, analysis services,browser, every thing is off, nothing is running, if i start to run, raising as error
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
If Full Text Search service isn't running, then start it, and when it has started, try launching SQL Server service.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image WilliamD commented ·
+1 That's what I said, just a little more concise.
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
I know, but it's possible that ramesh misinterpreted... ;-)
0 Likes 0 ·
Blackhawk-17 avatar image
Blackhawk-17 answered
Are you using Local System, a Local account or a Domain account to run the services under? Are there corresponding errors in the Windows Security log?
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.