SQL Server DB: where could I find the TCP port configured?
Created: 21 Dec 2012 | Updated: 21 Dec 2012 | 7 comments
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!
Discussion Filed Under:
Comments 7 Comments • Jump to latest comment
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
Thanks In Advance
Ashish Sharma
SEPM Knowledgebase Documents
Sorry but... have you read my question?
No offense but this is not the information I've requested
HI,
Check this thread also
https://www-secure.symantec.com/connect/forums/can...
Thanks In Advance
Ashish Sharma
SEPM Knowledgebase Documents
I've already read that post too
I'd like only to know if exist a conf file or a log with this information inside.
Thanks!
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
SEP Knowledge Base
Endpoint SWAT
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).
http://www.cstl.com/
$dbport=xxxxx
Perfect! Thank you!
Would you like to reply?
Login or Register to post your comment.