Bechir Gharbi at myITforum.com

The technology is with you anywhere you go

Tags

News

My old blog: http://bechir-gharbi-sccm.blogspot.com/

October 2011 - Posts

ConfigMgr 2012 : Could not connect or execute SQL query

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 :

image

In ConfigMgrSetup.log :

image

Cause:

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.

Solution:

You need to configure SQL Server to listen on a specific TCP Port (1433). Look at this link

FEP 2010 : Where can I find the scan log on the client computer ?

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)

image