Verify a SQL user? 1

[esmithbda]

We have a database app that users login to and they authenticate via SQL authentication. So in the SQL Server (2000) database, there are the actual SQL users and the passwords are managed by the server. (not a separate table that we query, but an actual SQL Server user)

I am now building a separate web front end on this tool, and different users are going to be logging in - one of the user types will be that SQL User.

How can I check their authentication using ASP.NET? The ASP.NET app itself runs as one of those users, so I don't need them to actually be that user, I just need to check to see if their password matches that for the user.

Anything I have searched for on this relates to checking users in a table - which I know how to do - this is checking against the actual SQL Users.

 

[ca8msm]

Could you just try accessing one of the database objects that these users should be able to access? With the correct login information it should work whereas, without it, it won't.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[esmithbda]

Sounds reasonable, thanks.

Connect with a separate connection string built with that user's name/pass, and then try and do a basic thing all users should be able to do, and if that fails, fail the login.

We do something similar with an Access tool that points to the same database, but that is in old VB/ADO and so I am just less familiar with the ASP.NET method of doing things.