iGene connects to Microsoft SQL Server using Microsoft’s JDBC driver for Java. For iGene to continue, it needs a valid JDBC URL and a username/password or trusted authentication setup.
Microsoft has their own documentation for Building a Connection URL that can be followed.
Normally it would look something like this:
jdbc:sqlserver://10.134.2.31:1401;databaseName=igene_test_db
The information for what each of these items relates to are shown below:
jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]
Normally you just need to change the below item replacing server ip address, port and database name
jdbc:sqlserver://<server ip address>:<port>;databaseName=<database name>
It’s vitally important that the SQL server is configured to allow remote connections via TCP. By default, remote TCP connections are not allowed.