Darrell Norton's Blog [MVP]

Sponsors

The Lounge

Wicked Cool Jobs

Syndication

Recent Posts

Tags

View more

News

  • Darrell Norton pic

    MVP logo

    View Darrell Norton's profile on LinkedIn

    Currently Reading:

    weewar.com

.NET User Group

Articles

Archives

Advertisement

Darrell Norton's Blog [MVP] » Preventing connection timeouts in SQL Server Enterprise Manager
Images in this post missing? We recently lost them in a site migration. We're working to restore these as you read this. Should you need an image in an emergency, please contact us at imagehelp@codebetter.com
Preventing connection timeouts in SQL Server Enterprise Manager

Sometimes in SQL Server Enterprise Manager, when I right-click on a SQL Server to “start” it, I get this error message:

A connection could not be established to (local).

Reason: Timeout expired.

Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the (local) node) and try again.

But after I click “Ok”, the SQL Server actually is started even though the error message says it’s not.

The solution is simple.  In SQL Server Enterprise Manager, click the Tools menu and select Options..  In the “SQL Server Enterprise Manager Properties” window that shows up, click the Advanced tab.  Change the “Login time-out (seconds):” default from 4 to 8.  Then click OK.

SQL Server Enterprise Manager Properties window with timeout set

Posted Wed, Mar 24 2004 7:56 AM by Darrell Norton
Filed under:

[Advertisement]

Comments

Henry Norris wrote re: Preventing connection timeouts in SQL Server Enterprise Manager
on Sat, Apr 10 2004 1:11 AM
Works like a charm!
Darrell wrote re: Preventing connection timeouts in SQL Server Enterprise Manager
on Sat, Apr 10 2004 6:14 AM
Henry - excellent, glad it helped!
Kaveendra Vithana wrote re: Preventing connection timeouts in SQL Server Enterprise Manager
on Sun, Jul 4 2004 5:07 PM
Thanks, it really worked.
Herve wrote re: Preventing connection timeouts in SQL Server Enterprise Manager
on Fri, Sep 17 2004 5:54 AM
It works. Thanx for that super simple solution
Darrell wrote re: Preventing connection timeouts in SQL Server Enterprise Manager
on Fri, Sep 17 2004 7:05 AM
Glad to help!
Dave wrote re: Preventing connection timeouts in SQL Server Enterprise Manager
on Tue, Nov 16 2004 3:24 AM
Your a star thanks..!
Phil wrote re: Preventing connection timeouts in SQL Server Enterprise Manager
on Wed, Dec 15 2004 7:09 AM
exact same problem... but the solution here doesnt work...
Could it be that Oracle being installed on the same server could conflict with SQL?
Darrell wrote re: Preventing connection timeouts in SQL Server Enterprise Manager
on Wed, Dec 15 2004 7:22 AM
Phil - not sure. I haven't messed around with Oracle in 5 years.
Devlicio.us