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
