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,
more ▼

asked Dec 20, 2010 at 12:59 AM in Default

ramesh 1 gravatar image

ramesh 1
2.2k 63 67 69

(comments are locked)
10|1200 characters needed characters left

3 answers: sort newest

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?
more ▼

answered Dec 21, 2010 at 06:19 AM

Blackhawk-17 gravatar image

11.9k 28 31 37

(comments are locked)
10|1200 characters needed characters left
If Full Text Search service isn't running, then start it, and when it has started, try launching SQL Server service.
more ▼

answered Dec 20, 2010 at 03:38 AM

ThomasRushton gravatar image

ThomasRushton ♦
34.2k 18 20 44

+1 That's what I said, just a little more concise.
Dec 20, 2010 at 04:19 AM WilliamD
I know, but it's possible that ramesh misinterpreted... ;-)
Dec 20, 2010 at 04:28 AM ThomasRushton ♦
(comments are locked)
10|1200 characters needed characters left

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

answered Dec 20, 2010 at 01:22 AM

WilliamD gravatar image

25.9k 17 19 41

sqlserver , agent services, analysis services,browser, every thing is off, nothing is running, if i start to run, raising as error
Dec 20, 2010 at 03:26 AM ramesh 1
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 20, 2010 at 12:59 AM

Seen: 1630 times

Last Updated: Dec 21, 2010 at 07:59 AM