Error connecting to SQL Server

Q&A
1

Hi all,

I'm trying to make a connector to a SQL Server (2008R2) database, but when I test it this error occurs:

java.lang.reflect.InvocationTargetException
org.bonitasoft.engine.bpm.connector.ConnectorExecutionException: org.bonitasoft.engine.core.connector.exception.SConnectorException: org.bonitasoft.engine.core.connector.exception.SConnectorException: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. 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.".

But firewall is off.

My connection driver is com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection URL is jdbc:sqlserver://localhost/SQLExpress:1433;databaseName=TestLocal7

Your help is appreciated very much!

Thanks, Jeroen.

2

Great, thanks for the quick answer! I assumed the use of standard TCP port 1433. But now I have actually set port 1433 in my SQL configuration, and it works!

Kind regards,

Jeroen

3

Hey, nice. :)

You are welcome.

4

Hi Jeroen.

"Make sure that an instance of SQL Server is running on the host and accepting TCP/IP "

Are you sure that your TCP/IP instance of SQL server is running and the ports are all set to 1433?

Best regards,