Connect To Database Engine does not respond

Question

Connect To Database Engine does not respond

monietamarind

SSC Veteran

Points: 268
More actions
August 23, 2010 at 7:19 am

#226106

I am trying to Connect To Database Engine. I was able to get connected before. But, I am not able to do so now. The SQL Server 2008 Management Studio does not even confirm any network-related error. Connect To Database Engine does not respond. Please help me with this. Thanks.

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

monietamarind (8/23/2010)
I am trying to Connect To Database Engine. I was able to get connected before. But, I am not able to do so now. The SQL Server 2008 Management Studio does not even confirm any network-related error. Connect To Database Engine does not respond. Please help me with this. Thanks.

do you get any error at all? by does not respond, do you mean you get a time out? the error , if any, would tell us everything.

the things i'd look for are:

could your windows credentials be expired? maybe you have hit a required password change today on the network? logout and login to be sure. you'd see other services acting wierd as well...Exchange, network shares, etc.

are you sure the service for the SQL is running? if it's not running, you'd get an error trying to connect.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

monietamarind SSC Veteran Points: 268 More actions · Answer 2

that's the thing. i haven't logged in for a number of days. and I don't believe I've changed the username/password/any settings.

Connect To Database Engine does not respond means that the window Connect To Database Engine just stays for a long time. I think, past 20 minutes already and I still do not get any error response.

jeff.mason SSCrazy Eights Points: 9585 More actions · Answer 3

Do you have another box you can use to try the same thing? Sounds like your client tools install is corrupt possibly.

Alan. T. Hall of Fame Points: 3221 More actions · Answer 4

Can you stop and start the SQL service? If it fails to start the windows log may be helpful.

MostInterestingMan SSCertifiable Points: 6291 More actions · Answer 5

monietamarind (8/23/2010)
that's the thing. i haven't logged in for a number of days. and I don't believe I've changed the username/password/any settings.
Connect To Database Engine does not respond means that the window Connect To Database Engine just stays for a long time. I think, past 20 minutes already and I still do not get any error response.

Is it the default sql instance or named instance. If it's a named instance make sure the sql browser service is not stopped; if it is that is your problem. Restart the service by going into the sql server configuration manager and you are good.

MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends

monietamarind SSC Veteran Points: 268 More actions · Answer 6

Would you mind posting step-by-step instructions as I am not too familiar with SQL Server 2008? Thanks.

Samuel Vella SSCrazy Eights Points: 8055 More actions · Answer 7

Easy thing to check in these instances is the network.

Open the windows command prompt and make sure you can ping the database server.

monietamarind SSC Veteran Points: 268 More actions · Answer 8

Yes, I can ping the database server. But, I still have the same problem.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 9

are you connecting to the database engine with SQL Server or Windows authentication?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Alan. T. Hall of Fame Points: 3221 More actions · Answer 10

Can you connect locally (on the machine itself)?

Can you connect by IP and not name?

MostInterestingMan SSCertifiable Points: 6291 More actions · Answer 11

monietamarind (8/25/2010)
Would you mind posting step-by-step instructions as I am not too familiar with SQL Server 2008? Thanks.

Here are the steps to get to the SQL Server Configuration Manager and Verify if SQL Browser Server is Running:

Start -> All Programs -> Microsoft SQL Server 2005/2008 -> Configuration Tools -> SQL Server Configuration Manager:

When Configuration Manager Opens, Select "SQL Server Services" in the left Pane and in the right pane all your SQL services will be listed. Look for SQL Browser Service and verify that it is started.

Now, just to be clear we are following the above steps only if the instance is a named instance. Also if you can post some error, any error message that will be really helpful.

Thanks,

MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends

monietamarind SSC Veteran Points: 268 More actions · Answer 12

MostInterestingMan (8/25/2010)
monietamarind (8/25/2010)
Would you mind posting step-by-step instructions as I am not too familiar with SQL Server 2008? Thanks.
Here are the steps to get to the SQL Server Configuration Manager and Verify if SQL Browser Server is Running:
Start -> All Programs -> Microsoft SQL Server 2005/2008 -> Configuration Tools -> SQL Server Configuration Manager:
When Configuration Manager Opens, Select "SQL Server Services" in the left Pane and in the right pane all your SQL services will be listed. Look for SQL Browser Service and verify that it is started.
Now, just to be clear we are following the above steps only if the instance is a named instance. Also if you can post some error, any error message that will be really helpful.
Thanks,

Perfect. Got it.