Forum Discussion

zhorvatic's avatar
zhorvatic
Occasional Contributor
8 years ago

JDBC connections with Instanced database names in NG PRO

Can somebody explain how to configure a database connection for a database that is hosted on: server\instanceName    In free version I could make a connection with ease, however in pro version I c...
Automation Environments
  • zhorvatic's avatar
    zhorvatic
    8 years ago

    I've managed to solve the problem by changing the database connection template in Preferences -> JDBC Drivers section.

     

    Driver:

    MSSQL(MicrosoftDriver)/com.microsoft.sqlserver.jdbc.SQLServerDriver

     

    Template:

    jdbc:sqlserver://<HOST:127.0.0.1>;databaseName=<DB>;user=<USER>;password=<PASSWORD>

     

     

    I just removed the <PORT:1433> section of the template and it allowed me to connect and set up my connections as I need them to.

     

zhorvatic's avatar
zhorvatic
Occasional Contributor
8 years ago

I've managed to solve the problem by changing the database connection template in Preferences -> JDBC Drivers section.

 

Driver:

MSSQL(MicrosoftDriver)/com.microsoft.sqlserver.jdbc.SQLServerDriver

 

Template:

jdbc:sqlserver://<HOST:127.0.0.1>;databaseName=<DB>;user=<USER>;password=<PASSWORD>

 

 

I just removed the <PORT:1433> section of the template and it allowed me to connect and set up my connections as I need them to.