Endpoint Protection

 View Only

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

    Posted Dec 21, 2012 06:48 AM

    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!



  • 2.  RE: SQL Server DB: where could I find the TCP port configured?

    Posted Dec 21, 2012 06:52 AM

     

    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

     



  • 3.  RE: SQL Server DB: where could I find the TCP port configured?

    Posted Dec 21, 2012 06:54 AM

    HI,

    Check this thread also

    https://www-secure.symantec.com/connect/forums/can-i-change-sql-port-1433-something-else



  • 4.  RE: SQL Server DB: where could I find the TCP port configured?

    Posted Dec 21, 2012 06:55 AM

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

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



  • 5.  RE: SQL Server DB: where could I find the TCP port configured?

    Posted Dec 21, 2012 06:57 AM

    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!



  • 6.  RE: SQL Server DB: where could I find the TCP port configured?

    Posted Dec 21, 2012 07:15 AM

    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



  • 7.  RE: SQL Server DB: where could I find the TCP port configured?
    Best Answer

    Posted Dec 21, 2012 08:07 AM

    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).



  • 8.  RE: SQL Server DB: where could I find the TCP port configured?

    Posted Dec 21, 2012 09:10 AM

    $dbport=xxxxx

     

    Perfect! Thank you!