As you know, ConfigMgr 2012 is supported on a SQL named instance. However, in this scenario when you try to install a primary site that will be joined to a CAS, you can get the following errors :
In ConfigMgrSetup.log :
ConfigMgr 2012 requires SQL Server to use static port TCP/1433 and TCP/4022 for SQL Service Broker if using a CAS or secondary sites. Since SQL Server named instances default to dynamic ports, if you are using named instances, you must manually reconfigure the named instance to use static TCP/1433.
You need to configure SQL Server to listen on a specific TCP Port (1433). Look at this link
Many people ask the question (Customers, on TechNet Forums, …) and on Forefront Endpoint Protection TechNet documentation we don’t find the name of the file.
People who worked on Forefront Client Security know the file because it is the same.
Location: %allusersprofile%\Microsoft\Microsoft Antimalware\Support
Name: MPLog-XYZ.log (XYZ is the date)