Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQL Server DB: where could I find the TCP port configured?

Created: 21 Dec 2012 • Updated: 21 Dec 2012 | 7 comments
diabolicus23's picture
This issue has been solved. See solution.

Example.

I don't have access to the SQL Server machine (so I cannot use SQL Server Management Studio and so on).
I cannot run netstat and so on (just an example).

Where could I read (on the SEP Manager machine) the TCP port used for DB communication (the one configured during the installation)?

I think there is a conf file inside wich this information is stored... or not?
Or a log that tell me "Open connection on xxxx server on yyyy port".

Thanks!

Comments 7 CommentsJump to latest comment

Ashish-Sharma's picture

The default port is typically 1433. You specify this port number when you create the database.

Best Practices guide for Installing the Symantec Endpoint Protection Manager with a SQL Server 2005 Database

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

About SQL Server configuration settings

Article:HOWTO55330  |  Created: 2011-06-29  |  Updated: 2011-12-17  |  Article URL http://www.symantec.com/docs/HOWTO55330

Thanks In Advance

Ashish Sharma

diabolicus23's picture

Sorry but... have you read my question? smiley

No offense but this is not the information I've requested smiley

diabolicus23's picture

I've already read that post too smiley

I'd like only to know if exist a conf file or a log with this information inside.

Thanks!

.Brian's picture

I know you can verify in the registry at:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\LastConnect

servername\instance key

I have not seen a conf file so this is a good question

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.

SMLatCST's picture

I'd suggest checking out the odbcutil.log file in %ProgramFiles%\Symantec\Symantec Endpoint Protection Manager\bin

This should get updated whenever the Management Server Configuration Wizard is run and will contain the SQL Server details (including the port).

SOLUTION