[SOLVED] Failed connecting to SQL Server


#1

Hi all,

I am testing the metabase.jar just running on my local Win 7 PC. Attempting to connect to our SQL Server.

Using a user account set up via SQL Server Management Studio, getting the errors:
Couldn’t connect to the database. Please check the connection details.
and
12-05 11:12:21 ←[1mERROR metabase.driver←[0m :: Failed to connect to database: Timed out after 5000 milliseconds

I can successfully use the account credentials to set up an ODBC connection from my PC.

Does the error suggest it is successfully contacting the host just not the database itself?

thanks

jc


#2

Can you show us the conneciton information? It probably can’t even find the server. When this happened to me, the port was wrong.


#3

I had left the port field blank as it had 1433 already in there as default. I manually entered 1433 and it now works!

So the grey text is not a default value?

jc


#4

Not in this case.