Forum Discussion

zhorvatic's avatar
zhorvatic
Occasional Contributor
8 years ago
Solved

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.

     

ByronJ's avatar
ByronJ
Occasional Contributor
8 years ago

Have you got the sql connector jar in your bin/ext folder?

 

If you added it recently, have you restarted ready!api/soapUI pro since?

 

Do you need to tunnel to get to the database?

  • zhorvatic's avatar
    zhorvatic
    Occasional Contributor
    8 years ago

    Yes, normal connection towards non-instanced server and database is established easily.

     

    There's no tunneling involved, it's a direct connection to a database server.