x

Cannot connect to DB Engine from SSMS

Hi,

I am getting this error when trying to connect the database engine (Sql Server 2008) using SSMS. any ideas to solve this problem? Thanks!

TITLE: Connect to Server

Cannot connect to "ServerName".


ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000238000 in file 'E:\Databases\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. (Microsoft SQL Server, Error: 823)

more ▼

asked Oct 26 '09 at 11:10 AM in Default

user-304 (yahoo) gravatar image

user-304 (yahoo)
11 1 1 1

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

2 answers: sort voted first

As the error message says, it sounds like master is not OK. You need to run a DBCC CHECKDB on master (run it on all of your databases to be sure). If you're lucky, it's a minor issue, or a problem with your I/O subsystem that is presenting itself as database corruption.

As CHECKDB author Paul Randal says, 99% of CHECKDB issues are caused by problems with your I/O subsystem, so making sure that you diagnose and solve the I/O subsystem issues should be your #1 priority right now.

For more info...

http://www.sqlservercentral.com/Forums/Topic355924-5-1.aspx#bm482958

http://msdn.microsoft.com/en-us/library/ms176064.aspx

http://www.sqlskills.com/blogs/paul/

more ▼

answered Oct 26 '09 at 11:20 AM

Aaron Alton gravatar image

Aaron Alton
565 2

This error occurs when trying to connect to a DB engine. It doesn't connect to the DB engine and I can't see any of the DBs in Object explorer of SSMS. How can I fire the query DBCC CHECKDB?
Oct 26 '09 at 12:40 PM user-304 (yahoo)
Good question. Try SQLCMD ( http://msdn.microsoft.com/en-us/library/ms170207.aspx). If that doesn't work, hopefully you have a backup, in which case you may need to restore master ( http://technet.microsoft.com/en-us/library/ms175535.aspx)
Oct 26 '09 at 04:02 PM Aaron Alton
(comments are locked)
10|1200 characters needed characters left

Look through your event log. It's basically saying

'I was half way through reading the data for the master database when the disk decided to tell me that it wasn't ready'.

This 'severe system-level error condition' bit isn't joking.

It's pretty likely though that you will see something in the error log at that time that tells you why that drive isn't being reliable.

more ▼

answered Oct 26 '09 at 11:22 AM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 87

All I can see is same error message in EventViewer -> Application Log (of Windows). Is there anything I am missing?
Oct 26 '09 at 12:46 PM user-304 (yahoo)
(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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1816
x123

asked: Oct 26 '09 at 11:10 AM

Seen: 2420 times

Last Updated: Oct 26 '09 at 11:43 AM