SQL Server ODBC link when using Windows Authentication

• al-948020

  Newbie

  Points: 8

  More actions

  March 30, 2009 at 7:45 am

  #198614

  Hi

  I am on a PC running Windows XP, logged in as MYPC-9AA4B4\Alistair McKinnon

  I want to create an ODBC link to another server running MS SQL 2005 under Windows Authentication

  I can remote into the other server using an IP Address, and a windows user name + password.

  There are 2 sql server log ins on the server:

  sa - which I don't want to use

  and

  XXSERVERDEMO\amckinnon which is my windows log in to that server.

  How do I set up the ODBC link to tie in the IP address, the SQL server name and the windows user?

  I keep getting "user '' not associated with trusted connection" messages.

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  March 30, 2009 at 10:23 am

  #968497

  I have covered the two context of your error and the known fixes of this problem in the thread below, you should also know your options are limited.

  http://www.sqlservercentral.com/Forums/Topic678990-359-1.aspx

  Kind regards,
  Gift Peddie