registering sql server on enterprise manager

  • hello

    on sql server enterprise manager , i open register sql server wizard

    click next 

    gave ip address of the sql server( i want to register) in available servers  and add it

    gave sql authentication

    but got the error sql server does not exist or access denied coonectionopen(connect())

    please advice me  how to solve this problem

    note: tcp/ip network library is enabled on my server

  • This was removed by the editor as SPAM

  • Can you ping the server from your machine? Do you have tcp/ip client library enabled on your local machine?

    Also, check the rights you assigned to the SQL account you are using.



    Michelle

  • thanx mimorr

    i just try to ping but it reports

    request timed out

    it did not received any packet

    i have enabled tcp/ip on sql client and server network utility

    the rights assigned are system administrator

    kindly reply

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

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