NT Authentication

[LostProgrammer]

All the programs I write need some form of authentication. Generally I create a users table in SQL server that authenticates for me. What I am thinking would be nice though is if I could somehow authenticate my users using NT's domain authentication. So I guess my question is this, can I pass a username and password from my .net program to my authentication server somehow so that it will tell me if this person is a valid user or not? By doing it this way all the users passwords would be dynamic and change when there server passwords change. Where as right now if they change there server password I have to manually go into my SQL Users table and manually reenter the password cause they like the passwords to match.

Any ideas?

LP

 

[quwiltw]

Maybe I'm missing something, but wouldn't turning on Trusted Connections do the trick? Then you'd never have to worry about user/password management.