How do I Automate PAssword change for SQL server account

13 May 2005 2:26 PM

Alex

Does anyone know a way to Automate Password change for SQL server account?

13 May 2005 3:17 PM

Narayana Vyas Kondreddi

There is nothing built-into SQL Server 2000 for this. You will have to setup
a job to do this, and the job or application will use sp_password to change
the password. It is upto you to decide how you want derive the new password,
and communicate that to the user. If you have any specific questions please
post back.

--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/

"Alex" <A***@discussions.microsoft.com> wrote in message
news:32B899FB-94A1-47AB-9A4B-EA8BA5428844@microsoft.com...

Does anyone know a way to Automate Password change for SQL server account?

13 May 2005 3:26 PM

Alex

Thank you very much for the responce. Do you have any sample code to do this
in a stored procedure?

Show quote

"Narayana Vyas Kondreddi" wrote:

> There is nothing built-into SQL Server 2000 for this. You will have to setup
> a job to do this, and the job or application will use sp_password to change
> the password. It is upto you to decide how you want derive the new password,
> and communicate that to the user. If you have any specific questions please
> post back.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
>
>
> "Alex" <A***@discussions.microsoft.com> wrote in message
> news:32B899FB-94A1-47AB-9A4B-EA8BA5428844@microsoft.com...
> Does anyone know a way to Automate Password change for SQL server account?
>
>
>

13 May 2005 3:27 PM

Anith Sen

Check SQL Server Books Online for details on sp_password. You will find a
couple of examples there as well.

--
Anith

13 May 2005 3:56 PM

Alex

I know how to use sp_password. Just wondering if there was any code samples
out there for a stored procedure that would automate this task.

Show quote

"Anith Sen" wrote:

> Check SQL Server Books Online for details on sp_password. You will find a
> couple of examples there as well.
>
> --
> Anith
>
>
>

13 May 2005 4:19 PM

JT

You would can schedule the execution of sp_password by creating a job. Be
careful about restricting access to this job and also resetting the SA
account pw.

Show quote

"Alex" <A***@discussions.microsoft.com> wrote in message
news:96549BD6-2862-40E2-9A4D-4C10951155AF@microsoft.com...
> I know how to use sp_password. Just wondering if there was any code
samples
> out there for a stored procedure that would automate this task.
>
> "Anith Sen" wrote:
>
> > Check SQL Server Books Online for details on sp_password. You will find
a
> > couple of examples there as well.
> >
> > --
> > Anith
> >
> >
> >