Post reply

connection failed,check sql server registration properties

  • April 1, 2009 at 11:32 pm

    #201685

    HI

    when i want to connect local sql server2000 from my local system to create or open database

    iam getting this error

    connection failed,check sql server registration properties

    pls suggest what to do

    Thanks in advance

  • April 2, 2009 at 12:07 am

    #970384

    Check the server properties and use mixed mode of authentication.(assuming u are connecting through sql login).

    Also check the protocols are enabled or not?

  • April 2, 2009 at 1:35 am

    #970411

    need more help

    i tried with mixed authentication but not working

    any othere solutions pls

  • April 2, 2009 at 2:18 am

    #970429

    try osql and see what error you are getting

    osql -E -S server_name

    or

    osql -U username -P password -S servername

    It seems you have forcefully registered that server in enterprise manager, and now it will always say "connection failed, check you registration", no matter what the error is.

    And also, please delete that registration and register the server again.

Viewing 4 posts - 1 through 3 (of 3 total)

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