Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: Application connection string using windows auth

    OK

    We have always used sql servwer login to the servers for all our applications for out intranet apps

    And we use windows auth to do development

    So when we do that we logon to wuindows, and then just connect, with no password required

    But how does an application "logon" to connect to a database

    Is it just in the connection string just like sql server auth

    or is it different?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    An in house app? It all depends on the connection string. In the connection string you either tell SQL Server to use windows authentication or the SQL Server login credentials provided.

  3. #3
    Join Date
    Feb 2008
    Posts
    21
    Here is a good site with example of connections strings. You can see that if the server needs password/username, you can put it in there. If it's just windows authentication, then no login specifics need to be provided.

    http://connectionstrings.com/?carrier=sqlserver2005

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •