HI all,
i made a program that connect with user "sa" to a SQL Server , but if anyone change password for user "sa" i'm not able to connect to the db.

Is there any way to retrieve password for one specified user in SQL?

Thank in advance
Bye

BRMC

____________________________
I don't mind not going to heaven
As long as they've got cigarettes
in hell

hi BMRC

individual users are created and assigned with passwords. only those users are allowed access to the database server. if any dummy passwords are used then there is no way u can control it. give ur own password and do not tell it to others. i think this is the only way. but even then the database administrator or the owner can change it.



____________________________
Life is at Stake; Make the most out of it!

hi thi,
i know but what i mean is , my program create new sql user but for do this i must be server administrator , the problem is that i should create a way indipendent to the modify of the user "sa".

One way is to create a server administrator but the program must workj only with user "sa".
So i need to retrieve , if modified , his password.

Or there is another way

Thanks
Bye  

____________________________
I don't mind not going to heaven
As long as they've got cigarettes
in hell

Well.... you could have a login on the SQL server that has read access to only one database (that no other login has access to)... then put the sa's password (encrypted!!!) in a table. Then have your program access the sa password DB, get & decrypt the password, then use it to connect as "sa"

but whatever... you'll have to have an account that has a non-changing password.

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)