Re: SMS and SQL SA password

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Henry C (hswchiu_at_hotmail.com)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 23:18:58 +0800

I believe the only possibility that you may break SMS 2003 by changing sa
account password is that you configure SMS 2003 to use sa account as the SQL
connection account. If not, I don't anticipate any issue with changing the
sa password.

"Jason" <jason.brimhall@questar.com> wrote in message
news:389b01c47eec$99d98e90$a601280a@phx.gbl...
Once SMS is setup and installed, how can I change the SQL
SA account password without breaking SMS 2003?

Relevant Pages

  • Re: SMS and SQL SA password
    ... Using the sa is the way SMS was setup. ... >Once SMS is setup and installed, how can I change the SQL ... >SA account password without breaking SMS 2003? ...
    (microsoft.public.sms.admin)
  • Re: Multiple primary sites?
    ... It was actually the Domain Administrator account password that was ... changed - not sure why that would affect SMS though, ... before I came aboard. ... I'll look into the SMS service account password ...
    (microsoft.public.sms.setup)
  • Re: SMS 2003 SP2 and SQL 2000
    ... most likely the issues is related to that you are using "core" SQL functionality to dump the database to the same file every time it back's up the SMS db. ... As Garth did mention you should disable all this SQL Server Agent jobs and rather rely on the SMS_SITE_BACKUP task instead, as it will backup all required components at the same point in time. ...
    (microsoft.public.sms.admin)
  • RE: local admin account password
    ... Subject: local admin account password ... 5)My main idea/plan is to store all the passwords on a central SQL server. ... There would be basically two stored procs, ...
    (Focus-Microsoft)
  • Cannot install SMS2003 Primary Site with SQL2000sp3a
    ... we got problems installing SMS 2003. ... it always pop a window say cannot locate the SQL Database or you dont have ... but we build that SQL Server 2000 sp3a right ...
    (microsoft.public.sms.setup)