Sounds like he is running SQL in mixed authentication mode. No, changing the SA password will not bother CM at all. It's generally advised to not even enable the SA account but some dba's think they just have to have it. (they don't)
From: [email protected] [mailto:[email protected]] On Behalf Of Brian McDonald Sent: Friday, March 14, 2014 1:22 PM To: [email protected] Subject: RE: [mssms] Changing the SQL Service Account PW Okay - thanks to everyone. I actually have a correction. I misunderstood what he was asking me. He is actually talking about the System Admin account for SQL. If he changes the password for this will it break SCCM? Thanks, Brian ________________________________ From: [email protected]<mailto:[email protected]> To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] Changing the SQL Service Account PW Date: Fri, 14 Mar 2014 14:00:06 -0400 Basically John is right now you MUST change it via the SQL Server Configuration Manager. And not from Services in control applet. Garth Jones Chief Architect www.Enhansoft.com<http://www.enhansoft.com/> [Description: Description: cid:[email protected]]<http://www.enhansoft.com/> Enhancing Your Business [Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<http://be.enhansoft.com/>[Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<https://twitter.com/enhansoft>[Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<http://www.facebook.com/EnhansoftInc>[Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Enhansoft's YouTube Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<http://myitforum.com/myitforumwp/community/groups/enhansoft/> See us at booth #1240<http://northamerica.msteched.com/#fbid=poJHUxb29bD> [TechEdExhibitor Button]<http://northamerica.msteched.com/#fbid=poJHUxb29bD> Ask Me About Our Free SSRS Reports<http://www.enhansoft.com/pages/Free-SSRS-Reports.aspx> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Marcum, John Sent: Friday, March 14, 2014 1:18 PM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] Changing the SQL Service Account PW I think all you'd need to do is go to the services, enter the new password and restart the services. (I think) From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Brian McDonald Sent: Friday, March 14, 2014 11:55 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] Changing the SQL Service Account PW Hey everyone, My DBA is knocking on my door requesting to change the SQL Service Account PW we have setup in our SCCM environment (local SQL). If this password is changed, what do we need to do from an SCCM standpoint to ensure nothing breaks. Thanks, Brian ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
<<inline: image001.jpg>>
<<inline: image002.png>>
<<inline: image003.png>>
<<inline: image004.jpg>>
<<inline: image005.png>>
<<inline: image006.png>>
<<inline: image007.jpg>>
