Symantec Endpoint Protection Manager 11 - Unable to Communicate with Reporting Component

• If you are on a 32-bit OS, skip the next step.
• If you are on a 64-bit OS, first go to 32-bit ODBC Control Panel. To do this do the following:

Go to %systemroot%\Windows\SysWoW64 folder (Example - Click Start -> Run -> C:\Windows\Syswow64 and click on OK)

Locate Odbcad32.exe & double click on the file

Click on System DSN Tab

You will find the "SymantecEndpointDSN" listed in the window.

Now click on the CONFIGURE button and proceed with the configuration of the DSN for the Symantec Endpoint Protection Manager 

• Open ODBC (using instructions above if on a 64-bit OS), then do the following:

Select Configure on the SymantecEndpointSecurityDSN 

Under the LOGIN tab set it to Supply User ID and password and type:
User ID: dba
Password: Login password to the SEPM 

Under the DATABASE tab configure these options:
Server Name: Name of Server
Database Name: sem5 (if you are using the embedded database) 

Under the NETWORK tab configure these options:
Check TCP/IP and enter: "host=IPAddressofServer" without the quotes. 

Now test connection. You should receive Connection Successful.

References:

http://www.symantec.com/connect/forums/unable-connect-reporting-component-symantec-endpoint-protection-mr2

http://www.symantec.com/business/support/index?page=content&id=TECH103990