Re: Advice on sa password change
From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 04/29/04
- Next message: Marc: "BULK INSERT from a mapped drive"
- Previous message: Alec MacLean: "Re: Granting EXEC to all my user sprocs in one hit"
- In reply to: Rand Boyd [MSFT]: "RE: Advice on sa password change"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 29 Apr 2004 13:53:11 -0400
Linked servers may break, but you will have to update the remote server
itself to fix the problem. Besides, you shouldn't be linking servers with
the SA login anyway.
-- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com I support the Professional Association for SQL Server www.sqlpass.org "Rand Boyd [MSFT]" <rboyd@onlinemicrosoft.com> wrote in message news:U%23$JPkfLEHA.3364@cpmsftngxa10.phx.gbl... > 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: Marc: "BULK INSERT from a mapped drive"
- Previous message: Alec MacLean: "Re: Granting EXEC to all my user sprocs in one hit"
- In reply to: Rand Boyd [MSFT]: "RE: Advice on sa password change"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
