Remote Connection Windows Authentication Error

• mvbokker

  SSC Veteran

  Points: 225

  More actions

  January 21, 2009 at 10:38 pm

  #204405

  Trying to connect to a remote database using SSMS and Windows Authentication.

  Server Type : Database Engine

  Server Name: 192.168.1.100,1433

  Authentication: Windows Authentication

  generates error:

  Login failed for user "". The user is not associated with a trusted SQL Server Connection. ....Error:18452

  What am I doing wrong?

• Old McDonald

  SSCertifiable

  Points: 5768

  More actions

  January 22, 2009 at 2:40 am

  #930944

  Did you try googling?

  - Check whether mixed authentication is enabled on your remote server.

  - Check whether the windows user has rights to connect to that server.

  and do google it..

  -Vikas Bindra

• mvbokker

  SSC Veteran

  Points: 225

  More actions

  January 22, 2009 at 10:22 pm

  #931632

  Yes of course, I googled...a lot!

  Mixed mode would not work, so I had to setup an account and that worked. Still have no answer why windows authentication failed..but no matter now.

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  April 10, 2009 at 10:31 am

  #975887

  Stupid question:

  Is the user account configured in SQL Server as login and as user for the database?

  Did you try to connect locally with the windows account?

  Greets

  Flo

• mvbokker

  SSC Veteran

  Points: 225

  More actions

  April 10, 2009 at 10:50 am

  #975899

  This worked as designed. Windows Authentication will not work for remote access. It worked fine using a userid/pwd.