Post reply

change password for startup Service.

  • May 23, 2002 at 9:23 am

    #57712

    Does anybody know the system stored procedure that will allow a user/dba to change the password for the SQL Server Services and SQL Server Agent?

    I have read article Q259710 on the Microsoft website that states that "you must manually use the SQL Ent.Mgr. to adjust the SA password for the SQL Server Agent on the target computer." But, I was told that this is relating to "connection properties" and not what we want to look for.

    Any and all ideas would be greatly appreciated.

    ML

  • May 23, 2002 at 10:25 am

    #429667

    There is no sp to change NT Service passwords. SQL Server Services and SQL Server Agent are running as NT services not inside SQL. What are you looking for?

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • May 23, 2002 at 11:23 am

    #429679

    Thanks for the help. We want to be able to apply a sql script to change those passwords from within sql query analyzer.

  • May 23, 2002 at 11:24 am

    #429680

    Thanks for the help. We want to be able to apply a sql script to change those passwords from within sql query analyzer.

  • May 24, 2002 at 9:01 am

    #429729

    I believe the answer is in Service Control Manager Utility found in the Binn directory. Does anybody have any experience with this?

  • May 24, 2002 at 9:26 am

    #429730

    AFAIK, you have to do this with some application. The Services applet in Control Panel is the most frequently used one. There might be a command line as well.

    Steve Jones

    steve@dkranch.net

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply