how to use NT Authentication account in SQL Server on asp.net website RRS feed

  • Question

  • User-80275147 posted


     My company wants to change an internal website that currently uses SQL authentication to Windows NT authentication.
    The web application connects with a SQL account. The user must log into the website using their SQL Account (username/password).

    It checks a user database to see if they have access to the database. Then from their (I believe) this determines if the user can load to the rest of the website where in then uses the main sql account in the webconfig file to do all the database connections. It uses forms authentication to keep users from circumnavigating the login screen.

    Question: How do I make it so the website checks an NT authentication account on the sql server database instead of a SQL authenication account.

    Can you please send me in the direction of a tutorial, lesson, code examples.

    Thank You


    Tuesday, October 30, 2007 4:11 PM