Continuing the discussion from SQLServerException on deploying WebAPI:
[quote=“vkramdev, post:1, topic:4823, full:true”]
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.
[/quote]@alfranke @richawilliams can you folks guide me in some direction.
