how 2 use windows authentication

• sqlpro

  Hall of Fame

  Points: 3859

  More actions

  January 27, 2004 at 7:56 pm

  #66251

  Hi friends i have following connection in vfp8 application that connects to sqlserver.this connection uses sql server login but how can i change following string to use windows authentication(our sql server accepts sql server logins and windows authentication as well). driver=SQL Server;server=houston;uid=RK;pwd=PWD;database=tracker;dsn= any ideas please Thank you very much

• chrisleonard

  SSCertifiable

  Points: 5030

  More actions

  January 27, 2004 at 10:23 pm

  #491858

  P Rajanikanth:

  The connection string you are using is a DSN-less style string, so you don't need the "dsn=" at the end.  So I'm assuming that the following connection string will authenticat a SQL Server login named RK with a password of PWD:

  driver=SQL Server;server=houston;uid=RK;pwd=PWD;database=tracker

  If so, then the following string will request Windows authentication instead, using the network credentials of the currently logged-in user:

  driver=SQL Server;server=houston;uid=;pwd=;database=tracker

  A slightly fuller explanation is available here:  http://support.microsoft.com/default.aspx?kbid=194641

  Cheers,

  Chris

• sqlpro

  Hall of Fame

  Points: 3859

  More actions

  January 28, 2004 at 12:33 pm

  #492052

  Thanks chris

  I found very useful website with connection strings

  http://www.connectionstrings.com

  its very useful

  Thanks for ur response.

  cheers

  Rajani