I agree--have Management justify, in technical terms, why it makes more sense technically to have the database on the SQL cluster. Not political reasons of "because there's a different team that manages SQL". If they've really thought it out, then here's the docs: https://docs.microsoft.com/en-us/sccm/core/servers/deploy/configure/use-a-sql-server-cluster-for-the-site-database
On Tue, Nov 29, 2016 at 11:23 AM, Kent, Mark <[email protected]> wrote: > Don’t put SQL offbox unless you absolutely have to. Usually no pros and > several cons in doing so. > > > > Mark Kent > > Manager, Client Systems Engineering > > Technology Support Services > > Resources for Information, Technology and Education (RITE) > > http://rite.buffalostate.edu > > > > *From:* [email protected] [mailto:listsadmin@lists. > myitforum.com] *On Behalf Of *Conrow, Kevin - conrowkm > *Sent:* Tuesday, November 29, 2016 11:53 AM > *To:* [email protected] > *Subject:* [mssms] New site installation > > > > We are setting up a new site with ConfigMan CB. Management wants to host > the database on our SQL cluster. Does anyone know if using a CNAME is > supported in the setup wizard when it prompts for database information? > Are there any “gotchas” we should look out for in this kind of setup (SQL > cluster)? > > > > Appreciate any feedback… > > > > Thanks, > > Kevin > > > > -- Thank you, Sherry Kissinger My Parameters: Standardize. Simplify. Automate Blogs: http://www.mofmaster.com, http://mnscug.org/blogs/sherry-kissinger, http://www.smguru.org
