Jason This is interesting to know. I always advise customers not to use the database for any other reason beyond Configmgr and susdb, normally through common sense rather than licencing.
Do you a link to the MS support statement on this so I can fire at will at customers? Thanks Paul. > On 18 Nov 2014, at 17:14, Jason Sandys <[email protected]> wrote: > > Enabling SQL auth does not affect Windows auth, it just enables SQL auth in > addition to Windows auth. SQL auth is less secure than Windows Auth by its > very nature of not being centrally controlled or managed so that's why it's > considered not a best practice to use or enable. > > > Also note that based on the licensing agreement, you are not allowed to use > non-System Center applications with your instance of SQL Server used for > ConfigMgr. > > > J > > From: [email protected] <[email protected]> on > behalf of Paul Winstanley <[email protected]> > Sent: Tuesday, November 18, 2014 3:00 AM > To: [email protected] > Subject: Re: [mssms] Windows and sql auth on a ConfigMgr database server > > Yes Windows auth is best practice however you can run in mixed mode if there > is a requirement. > > > > On 18 Nov 2014, at 07:32, David O'Brien <[email protected]> wrote: > >> I can’t talk about supported, but I had a lot of customers requiring SQL >> auth, because that’s what they used for their backup/maintenance tools on >> the DB. Never had an issue and can’t really see why there should be one. >> >> Cheers >> David >> >> From: [email protected] [mailto:[email protected]] >> On Behalf Of Corkill, Daniel >> Sent: Tuesday, 18 November 2014 6:26 PM >> To: [email protected] >> Subject: [mssms] Windows and sql auth on a ConfigMgr database server >> >> On my ConfigMgr site server (which is also my database server), I have a >> requirement to enable SQL auth. I’ve reviewed the SQL Server requirements >> section of the ConfigMgr supported configurations documentation and it >> states Windows auth is required but I just want confirm there won’t be any >> issues by having both SQL and windows auth enabled. >> >> Daniel. >> >> >> ********************************************************************* >> This email, including any attachment, is confidential to the intended >> recipient. It may also be privileged and may be subject to copyright. If >> you have received this email in error, please notify the sender immediately >> and delete all copies of the email. Any confidentiality or privilege is not >> waived. Neither the Council nor the sender warrant that this email does not >> contain any viruses or other unsolicited items. >> >> This email is an informal Council communication. The Council only accepts >> responsibility for information sent under official letterhead and duly >> signed by, or on behalf of, the Chief Executive Officer. >> >> Privacy Collection Notice >> Logan City Council may collect your personal information, e.g. name, >> residential address, phone number etc, in order to conduct its business >> and/or meet its statutory obligations. The information will only be accessed >> by employees and/or Councillors of Logan City Council for Council business >> related activities only. If your personal information will be passed onto a >> third party, Council will advise you of this disclosure, the purpose of the >> disclosure and reason why. Your information will not be given to any other >> person or agency unless you have given us permission or we are required by >> law. >> > >
