MSSQL Enterprise Manager

Discussion in 'Databases' started by hangman, Jul 17, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. hangman

    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
     
    hangman, Jul 17, 2004
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    what is the version of your sqldmo.dll file?

    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">
     
    Bruce, Jul 19, 2004
    #2
  3. tourneymanagerpro

    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.
     
    tourneymanagerpro, Jul 27, 2004
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page