Change sql user password from within VB

[Mirak]

Hi
I want to code a form that will enable the user to change his/her password from with a VB application. I already have the form to allow the user to connect to sql server in the vb application. But now i want to allow the user to change his logon from within the vb application. Is this possible? How can I search for the user's password on sql server?

thanks

 

[bboffin]

There are several ways of signing on to SQL Server
1) Everybody uses the same SQL username and password
2) Each user has his/her own SQL username
3) A trusted connection is used where the user's Windows logon name and password are used.

Which one are you using?




Bob Boffin

 

[Mirak]

2) Each user has his/her own SQL username and password
I am not using a trusted connection.

 

[vidru]

You won't be able to pull their existing password out of the db. Look up the system stored procedure sp_password in Books Online (aka SQL Server help files). It takes 3 arguments: OldPassword, NewPassword, and Login.

-dave