Post reply

New SQLServer Registration Error.

  • October 20, 2008 at 12:53 am

    #94677

    Hi All,

    My problem is We are having an online server and i want to connect to it using Enterprise manager.

    *Note: I am able to connect using Query analyser.

    In Enterprise manager i am right clicking on my production group and then selecting a New SQL Server Registration. I am doing this process through SQL Server Authentication Mode.

    After that i am getting this message

    SQL Server Registration Complete

    TimeOut Expired

    An then i am selecting the properties and giving the password for that server then i am getting this error.

    SQLServer Registration failed because of the connection Failure displayed below.

    TimeOut Expired.

    Help me to solve this problem.

    Syed Sanaullah Khadri.

  • October 20, 2008 at 7:33 am

    #887097

    It seems like an authentication/connection issue?

    Can you ping the host server?

    Can you configure an ODBC connection to the source using the account you're trying to use to register the SQL Server?

  • October 21, 2008 at 3:11 am

    #887487

    Hi,

    I have seen using ping, its working fine. I dont know about odbc can you tell me how to configure it.

    I am able to connect it using query analyser and that user is working with other systems.

    Mine OS is 2000 server and the server is which i am trying to connect is 2003 server will it make any difference.

    Please help......

    Thanks

    Syed Sanaullah Khadri

  • October 21, 2008 at 3:19 am

    #887489

    It may be just a slow connection, and Enterprise Manager is timing out before it is able to complete the registration fully:

    Increase your Enterprise Manager's login timeout threshold.

    Open Enterprise Manager and go to 'Connection Settings' (Tools -> Options -> Advanced).

    Increase the 'Login time-out setting as required (seconds) to 20 or 30 seconds to prevent the time out.

  • October 21, 2008 at 3:40 am

    #887492

    Hi,

    Thanks for your support, initially it was 4 sec i have increased it to 20 and now i have registered it successfully.

    I learned one new thing today.

    Thankyou.

    Syed Sanaullah Khadri

  • October 21, 2008 at 3:42 am

    #887495

    No problem 🙂

  • October 21, 2008 at 4:05 am

    #887499

    Please check the latest MDAC installed in your machine if exists, then better install SQL Server client tools once again.

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

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