Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-10 : 08:43:53
|
| Sid writes "Hi, can anybody plz provide me the stored procedure for checking the credentials(uid,Pwd) of a login page in sqlserver.Thanks,Sid." |
|
|
BIGGY
Starting Member
17 Posts |
Posted - 2006-03-10 : 16:43:00
|
| Not sure if this will be of help. I can tell you the idea since I don't have the code at the moment. But I did something similar to this in access. Basically after the user entered their name and left the field, their password was loaded into a hidden/temporary field from the table storing them and then verified against the password they enter. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-10 : 16:46:57
|
| Sid,Are the login credentials SQL authentication, Windows Authentication, or custom application authentication? If either of the first 2, then you just want to get logged in successfully. If the application gets an error returned, then either the userid or password or both are wrong. For custom application authentication, we'd need to need the table design for it in order to help.Tara Kizeraka tduggan |
|
|
|
|
|
|
Need a SqlServer Stored Procedur to check Login credentials