Post reply

how 2 use windows authentication

  • 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

  • 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

  • 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

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

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