question

Leo avatar image
Leo asked

SQL Service Not Starting after installation

Hi,

Just build the new development server and installed couple of instances with SQL 2008. Restart the Server after installing SQL2000BC and SQL200DTC, now getting error saying Device Not Ready and SQL not starting.

Any Idea?

sql-server-2008
10 |1200 characters needed characters left characters exceeded

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

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered

Without more information, it's hard to say, but the most frequent errors are security related. Check all the services and the accounts they're using. The second most frequent error is network related. Do you have the write protocols enabled? The third most frequent error is path related. Do you have all the right data drives, etc.

AFter that, you have to be driven by the error message.

2 comments
10 |1200 characters needed characters left characters exceeded

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

am getting following message in event viewer - The description for Event ID ( 17147 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: also in system - The SQL Server (MSSQLSERVER) service failed to start due to the following error: The device is not ready.
0 Likes 0 ·
Device not ready sounds like hardware. Are all the drives online and accessible? Are they accessible to the account that SQL is running under?
0 Likes 0 ·

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.