HELP HELP HELP.... tried to connect to a remote SQL Server

• Dove-265763

  SSC Veteran

  Points: 264

  More actions

  July 5, 2006 at 8:05 pm

  #118540

   WHen i tried to connect to a remote SQL Server I encountered the following issues. Please see the error logs and suggest the possible solution if you hvae time,  

   

     Please find the following details:-

   

                   Scenario 1

   

  1. Logged in to Enterprise manager
  2. Clicked on “New SQL registration”
  3. Add server IP “10.193.16.177”
  4. Selected Authentication mode as “SQL Server”
  5. Keyed in Login name as “N800\harihan_lavanya” and the password

   

  When they click on finish they are getting an error stating “Login failed for User N800\Harihan_Lavanya”

   

                  Scenario 2

   

  1. Log into Enterprise Manager using “Run as” option and login using “N800\Harihan_lavanya”.
  2. Clicked on “New SQL registration”
  3. Add server IP “10.193.16.177”
  4. Selected Authentication mode as “NT Authentication”

   

  When they click on finish they are getting an error stating “Login failed for User N800\Harihan_Lavanya”

   

  Again, we also tried using Mixed Mode Authentication but it’s failing also… 

   

  1. Regarding the Connectivity Issue the SQL Server Registration Property is showing the same error during registering to the IP: 10.193.16.177. The Error screen is as following: 

   

  

   

  2.And if I try with the RunAs Current User and for the New registration to the same IP, it gives the following Error Screen:

  

  Regards,
  Dove

• Minaz Amin

  SSChampion

  Points: 11052

  More actions

  July 6, 2006 at 5:08 am

  #647706

  Hi,.....

  This is a very good KB on connectivity issue.

  http://support.microsoft.com/kb/827422/en-us

  Hope this will help..

   

  Minz.

  "More Green More Oxygen !! Plant a tree today"