We have recently brought in a frequent change password policy in our
company. However whenever I change my password I lose all my registrations,
and it is getting annoying now. Is there anyway around this ?Look at the following article:
FIX: Registered remote servers disappear from SQL Enterprise Manager in
Windows XP when user password is changed
http://support.microsoft.com/default.aspx?scid=kb;[LN];323280
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Paul,
presumably you are talking about the SQL login's password
that you are using to register SQL Server in Enterprise
Manager? If so, then you could use windows authentication
to register the tool.
If you are referring to the SQL Server and/or Agent
Service and their window's logins, then AFAIK there's no
automatic way of resetting them when the password is
changed in AD - the problem is not apparent if you use the
LocalSystem account but this is only viable if you're not
using replication, Exchange mail integration etc.
HTH,
Paul Ibison
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment