Updating SQL Password via Connection String Property

[RileyCat]

Is there a property in the connection string to SQL via ADO.Net that says to change the password for the incoming User Id to the password that is provided?

I am trying to write an application and/or DLL that will programmatically change an sql user Id's password. I know sp_Password works in a query window but as far as I know, that only works if the user is an admin of the user Id that is being updated.

Any ideas?

Stay Cool Ya'll!

-- Kristin

 

[BrianB]

Wouldn't they need to login first before being allowed to change their password?

Why not log in, then call sp_Password?

Brian Begy
Chicago Data Solutions

http://www.chicagodatasolutions.com

BugSentry needs beta testers!

http://www.bugsentry.com