RE: Advice on sa password change

From: Rand Boyd [MSFT] (rboyd_at_onlinemicrosoft.com)
Date: 04/29/04

  • Next message: Alec MacLean: "Re: Granting EXEC to all my user sprocs in one hit" 
    Date: Thu, 29 Apr 2004 14:48:29 GMT

    If you are wondering about things that might break when you change the
    password:

    Look at all DTS packages - Connection properties to this SQL Server. Also
    any scheduled DTS package that was scheduled in Enterprise Manager while
    logged in as the sa account will have to be resecheduled.

    Look at all replication agents to make sure they are not using the sa
    account to connect to this server.

    Look at all other jobs as well.

    Any client application that uses the sa account to connect to this server
    will need to be modified to account for the new password.

    There are probably some things that I have missed but these have been the
    ones that have caused the most problems when the sa password is changed.

    Rand
    This posting is provided "as is" with no warranties and confers no rights.

  • Next message: Alec MacLean: "Re: Granting EXEC to all my user sprocs in one hit"

    Relevant Pages

    • Re: Advice on sa password change
      ... Microsoft SQL Server MVP ... I support the Professional Association for SQL Server ... > any scheduled DTS package that was scheduled in Enterprise Manager while ... > logged in as the sa account will have to be resecheduled. ...
      (microsoft.public.sqlserver.security)
    • Re: Re-Post - "the trust relationship between this workstation and the
      ... "the trust relationship between this workstation and the primary domain ... only problem is adding a new user account on the station. ... Client computer must use STRICTLY the INTERNAL DNS server which can ... Attr: subschemaSubentry ...
      (microsoft.public.windows.server.active_directory)
    • Re: Same question, still no answer!!!
      ... Sounds then like we are all paying for a feature set only large companies ... The "proxy server" pc is actually an older box stuffed ... Expectation #1) keep the ethernet more or less as is. ... The kids account would be ...
      (microsoft.public.windowsxp.basics)
    • Re: Re-Post - "the trust relationship between this workstation and the
      ... "the trust relationship between this workstation and the primary domain ... only problem is adding a new user account on the station. ... This would be on the DNS server 172.20.100.2 ... Attr: subschemaSubentry ...
      (microsoft.public.windows.server.active_directory)
    • Sending email to mydomain.com
      ... server will appear as undeliverable. ... This happens because you are using the POP3 connector... ... an NDR when an account doesn't exist). ... >different from the user account names for the exchange ...
      (microsoft.public.windows.server.sbs)