Video Screencast Help

ITA connection ports required for SEP 11 SQL database

Created: 07 Feb 2013 • Updated: 11 Feb 2013 | 3 comments
etillman's picture
This issue has been solved. See solution.

Please advise what are the standard ITA connection ports required for SEP 11 SQL database access.  ITA server is behind the firewall and the SEP SQL server is on the corp network.

 

Pleased advise.  Thank you!

Comments 3 CommentsJump to latest comment

_Brian's picture

It connects to the SQL DB so you would need to verify with the DB admin on which port SQL uses

How to configure IT Analytics to connect to the SQL Analysis Services and SQL Reporting Services

Article:HOWTO39473  |  Created: 2011-01-07  |  Updated: 2011-01-11  |  Article URL http://www.symantec.com/docs/HOWTO39473

 

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

etillman's picture

The SEP 11 manager connects to the off box SEP SQL database on port 1433.  However when we attemp to access create a connection with the SEP sql database from ITA server we see traffic attempts from ports 445 and 1434.

Rafeeq's picture

TCP port 1433 and UDP port 1434 need to be opened and listening both ways from SEPM Server to Remote SQL and from Remote SQL to SEPM Server in order for the SEPM to communicate with the SQL database.

http://www.symantec.com/business/support/index?pag...

 

TCP port 445 is used for direct TCP/IP MS Networking access without the need for a NetBIOS layer.

http://www.symantec.com/business/support/index?pag...

SOLUTION