none
Accessing SQL Server using a SPECIFIC Active Directory Account RRS feed

  • Question

  • I have a .Net executable, NOT a web application.  I am required to access SQL Server 2008 using a SPECIFIC Active Directory account, NOT Windows Authentication for the active user.

    Again the specifics:

    • .Net stand-alone executable, NOT a web app
    • Access SQL Server 2008
    • use a SPECIFIC Active Directory account, not Windows Authentication

    Thanks

    • Moved by Bob Beauchemin Thursday, May 5, 2011 7:11 PM Moved to a more relevent forum (From:.NET Framework inside SQL Server)
    Thursday, May 5, 2011 2:08 PM

Answers

  • The simple answer is that there is no integrated authentication between SQL Server and Active Directory accounts unless you are using Windows Integrated Security.

    If you want to login using a specific Active Directory account then you will need to create a matching account in SQL Server and use SQL Server authentication to log in. The credentials (user ID and password) will need to be passed in the connection string. Also, you will need to configure SQL Server for Mixed Mode authentication.


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Thursday, May 5, 2011 11:15 PM