MSSQL Enterprise Manager

[hangman]

When I use SQL Server Enterprise Manager and tried to select the
Database in the tree, it timeouts. However, If I open the db in Studio.NET or Web Matrix, it is alright. I really need Enterprise Manger to work, for it is the only tool I have to create tables.
I download Service Pack 3a and same results. I think it must be your MSSQL because I can open my LOCALHOST MSSQL just fine. What is the next step? In fact I created a a temp.udl file that creates a test connection to MSSQL05 and it works. But EM doesn't. I am in dire straits. Help

[bruce]

what is the version of your sqldmo.dll file?

[b]quote:Originally posted by hangman

When I use SQL Server Enterprise Manager and tried to select the
Database in the tree, it timeouts. However, If I open the db in Studio.NET or Web Matrix, it is alright. I really need Enterprise Manger to work, for it is the only tool I have to create tables.
I download Service Pack 3a and same results. I think it must be your MSSQL because I can open my LOCALHOST MSSQL just fine. What is the next step? In fact I created a a temp.udl file that creates a test connection to MSSQL05 and it works. But EM doesn't. I am in dire straits. Help


</blockquote id="quote"></font id="quote">

[tourneymanagerpro]

If you have SP 3a installed, check your login timeout property. From Enterprise Manager, click on Tools -> Options -> Advanced tab to find the login timeout. From SQL Query Analyzer, click on Tools -> Options -> Connections tab. Adjust the login timeout as needed. I personally have mine set to 15 seconds which worked OK when I had a dial up account.