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.