OHDSI Home | Forums | Wiki | Github

SQLServerException on deploying WebAPI

Hi

I have configured postgres as my database and deployed the war file for WebAPI on tomcat . I find the error as below on the startup logs

"SEVERE: Unable to create initial connections of pool.
*com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host serverName, port 1433 has failed. Error: “serverName. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”

When i checked in the pom file i found that it mentions as below

<!-- Primary DataSource -->
    <!-- default sql server - TODO How about making postgres the default (e.g. in line with open source tech)? -alexfranken -->
    <datasource.driverClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</datasource.driverClassName>
    <datasource.url>jdbc:sqlserver://serverName;databaseName=databaseName</datasource.url>
    <datasource.username>user</datasource.username>
    <datasource.password>password</datasource.password>

How ever in the installation guide there is no mention of any primary datasource .Am i missing something.
Any guidance or help is appreciated.

t