System Center 2012 Configuration Manager SQL recommendations

I have two SQL related question that comes up in all of my ConfigMgr 2012 projects. Those are:   · Where are we going to install the SQL server? · How are we going to configure SQL? Where are we going to install the SQL server Answering the first question often ends in a political discussion between the ConfigMgr. administrators on one side and the SQL DBA’s on the other side. Most of the ConfigMgr. administrators that I know, strongly believe in having a local SQL installation. I’m also a true believer of that for several reasons. Remote SQL installations [...]

By |2017-12-18T16:11:50+01:00august 18th, 2012|Configuration Manager (SCCM), General info|29 Comments

Firewall rules for a SCOM Management Server

Want to keep the local firewall on your management sevrers and the SQL? Use the following commands to open what you need – Remember to run these the commands on each Management Server in the Resource pool you use for network monitoring.   On the SQL Server: Run this at the SQL Server who is to be Database server for your Management Servers netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN netsh advfirewall firewall add rule name = SQLBrowserPort dir = in [...]

By |2017-08-22T13:04:01+01:00august 15th, 2012|Operations Manager (SCOM)|3 Comments