Use of the Sql Server Instance dynamic port Hot

by Damien DUJARDIN on April 04, 2016

We are trying to use the dynamic port of an SQL Server Named Instance

It's a great feature of SQL Server.

But SBM Configurator requires an explicit port to connect to an SQL Server database.

  • We are trying to use the dynamic port of an SQL Server Named Instance

    It's a great feature of SQL Server.

    But SBM Configurator requires an explicit port to connect to an SQL Server database.

    In the ODBC DSN and the JDBCURL generated by the SBM configurator, port should not be set if the standard port (1433) is used.

    for example, remove the port of the ODBC DSN : "SERVERHOSTINSTANCENAME,1433"
    and modify the jdbc url of the context.xml file:
    url="jdbc:jtds:sqlserver://SERVERHOST;instanceName=INSTANCENAME:49616/;databaseName=DBNAME"

     

     

  • Please login to view any attachments.

  • This idea has not received many votes in 24 months since its submission. It has been closed (declined) due to insufficient support.
    David J. Easter Commented by David J. Easter June 04, 2018
    #1 Reviewer  -  

    This idea has not received many votes in 24 months since its submission. It has been closed (declined) due to insufficient support.

     

Print