HI All,
Not able to establish the connection, please advise
Driver used:
[sqlazure]
displayName = SQLAzure
useConnectionPool = false
jdbcDriverClass = com.microsoft.sqlserver.jdbc.SQLServerDriver
serviceClass = com.splunk.dbx2.MSSQLJDBC
defaultPort = 1433
jdbcUrlFormat = jdbc:sqlserver://<host>:<port>;databaseName=<database>
testQuery = SELECT 1 AS test
Failure message - :
Connection failure reason:
The TCP/IP connection to the host projectmanagerbyshreyas.database.windows.net, port 1433 has failed. Error: "connect timed out. 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.".
Diagnosis:
Either the database is unavailable, or the specified host/port is incorrect, or you are blocked by a firewall
Troubleshooting recommendation:
Make sure the database is running on the server and you or the database are not blocked by a firewall
Thanks in advance
... View more