Post reply

ssms connect to database engine hangs

  • February 8, 2011 at 10:26 am

    #246388

    After installing Oracle 11g client on our server I can no longer connect to SSMS database engine. I can connect to Reporting Services, Analysis Services and Integration Services but not the database engine.

    I tried restaring MSSQLSERVER and it timed out.

    Have I messed up my SQL Server client tools somehow? Can I just reinstall the tools?

    Any ideas on what I can check? Or correct? It's SQL Server 2008 R2, sandard ed, 64 bit.

    Any idease are greatly appreciated. Thanks.

  • February 8, 2011 at 10:35 am

    #1283857

    Can you check the error log, what message you get.

    C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG

    M&M

  • February 8, 2011 at 10:40 am

    #1283865

    No error messages are in the log. I saw the time out messages in the Event View system log.

    A timeout (30000 milliseconds) was reached while waiting for a transaction response from the MSSQLSERVER service.

  • February 8, 2011 at 10:51 am

    #1283872

    Rebooting the server seems to have fixed it. Thanks very much.

  • February 9, 2011 at 2:31 am

    #1284280

    You are welcome 🙂

    M&M

  • March 28, 2013 at 6:10 am

    #1601581

    Hi,

    We have similar kind of issue, We have 9 instances running on windows 2008 box. All are 2008 R2 instances. We have problem with only one instance.

    We are not able to connect to instance with any logins. Tried restarting services & server it is allowing first time and after that it is throwing connection timeout error.

    Could you please help me to fix the issue.

  • March 28, 2013 at 6:15 am

    #1601583

    03sunil (3/28/2013)

    Hi,

    We have similar kind of issue, We have 9 instances running on windows 2008 box. All are 2008 R2 instances. We have problem with only one instance.

    We are not able to connect to instance with any logins. Tried restarting services & server it is allowing first time and after that it is throwing connection timeout error.

    Could you please help me to fix the issue.

    you should start a new thread on this, but you should be able to bring that instance up in single user mode, and then use SQLCMD to add a sysadmin:

    http://beyondrelational.com/modules/2/blogs/115/posts/11143/how-to-access-a-newly-installed-sql-server-2008-r2-instance-if-you-do-not-know-the-login-and-passwor.aspx

    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!

  • March 28, 2013 at 6:35 am

    #1601593

    Thank you very much for your quick reply Lowell.

    I will start with new topic.

    Thanks,

    Sunny.

Viewing 8 posts - 1 through 7 (of 7 total)

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