Check user's password of MSDE

[ad]

I am using MSDE as the database of my program.

At the begin of my program, it must display a form for user to enter the
password

After the user enters the password, I will check the password, if it is the
correct password of a user of MSDE

..

In order to check the password; I must get the password of a user of MSDE in
the first.



How can I get the password of a user of MSDE? Like that I have a sa2 in MSDE
, how can I get the password of sa2?

 

[psg]

In order to check the password; I must get the password of a user of MSDE
in
the first.

Why don't you try to connect with username and password that user provided
and let MSDE to check if they are correct? Then you won't need to know user
passwords.

RGDS PSG

 

[Amy L.]

From a security perspective that's a very bad approach. You should attempt
to log in with those credentials passed and than let MSDE check the
Password. If the password is an error an exception will be thrown.

Amy.

 

[ad]

But there are many situations when we fail to login MSDE, like the MSDE is
stop or the net is disconnected

How can I confirm the failure is caused by incorrect password?

 

[psg]

But there are many situations when we fail to login MSDE, like the MSDE is
stop or the net is disconnected

How can I confirm the failure is caused by incorrect password?

Just handle an exception message (message from MSDE about error type).
When MSDE is down you will probably get error no. 17 "Connection failed...
Server does not exist or access denied.", when it is up, but wrong
user/password error no. 18456 "Login failed for user ...".

RGDS PSG