Cannot Connect Bonita to an SQL Server in Version 7.0
I'm trying to create a SQL Server connector, but i CANT.
So, this is what i am doing:
Development --> Connectors -> Test Connectors:
1) SQL SERVER
2) Connector Type:
3)Driver Selection
4) Driver and Access Configuration
3)Driver Selection
5) Query
6) Scripting Mode
7) Result Type
8) Dependencies
Result:
java.lang.reflect.InvocationTargetException org.bonitasoft.engine.bpm.connector.ConnectorExecutionException: USERNAME=install | 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: No se pudo realizar la conexión TCP/IP al host nexions-desa, puerto 1433. Error: "connect timed out. Verifique las propiedades de conexión, compruebe que hay una instancia de SQL Server ejecutándose en el host y aceptando las conexiones TCP/IP en el puerto y compruebe que no hay ningún firewall bloqueando las conexiones TCP en el puerto."
Check the connection properties, check that an instance of SQL Server running on the host and accepting TCP / IP connections on port and confirm that there is no firewall blocking TCP connections on port.
If I use URL like jdbc:sqlserver:nexions-desa\SQLEXPRESS:1433;databaseName=ANMAT instead of jdbc:\sqlserver://nexions-desa\SQLEXPRESS:1433;databaseName=ANMAT
This is the error i get:
java.lang.reflect.InvocationTargetException org.bonitasoft.engine.bpm.connector.ConnectorExecutionException: USERNAME=install | 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: java.sql.SQLException: No suitable driver found for jdbc:sqlserver:nexions-desa\SQLEXPRESS:1433;databaseName=ANMAT
Any idea what i am doing WRONG?
Thanks!
Finally resolved.
The Windows firewall is usually the culprit in these scenarios. Open TCP port 1433 for the service itself, and 1434 if you need to use the SQL Browser service. Open cliconfg from a RUN prompt and make sure TCP/IP is an enabled protocol. For SQL 2005/2008/2008 R2: Check the Services tool, Start > Administrative Tools > Services, to see that the service named SQL Server (MSSQLSERVER) is started.
For MS SQL 2012: Use the Windows key or hover over the left lower corner of the desktop and select Administrative Tools, then Services to see that the service named SQL Server (MSSQLSERVER) is started.
Ensure that you are using the correct credentials to authenticate. The default SQL administrator account is named sa and if you built the server from one of our server images with MSSQL pre-installed, the password will be in a text file on the root of the C partition. Use netstat –an from the command prompt to verify that the server is listening for SQL traffic on the correct ports. If the server is not listening for SQL traffic on the correct ports, use SQL Server Configuration Manager to change the ports. For MS SQL 2005/2008/2008 R2, go to Start > All Programs > Microsoft SQL Server 2005 (or 2008/2008 R2) > Configuration Tools > SQL Server Configuration Manager. For MS SQL 2012: Use the Windows key or hover over the left lower corner of the desktop and select All Programs > Microsoft SQL Server 2012 > Configuration Tools > SQL Server Configuration Manager.
Open the + next to SQL Server Network Configuration. Right-click TCP/IP and select Properties. Select IP Addresses. All TCP ports mentioned on all interfaces should be 1433. Change this to reflect the correct port number and restart the SQL services. If you are using named instances when installing SQL, giving you the ability to host multiple SQL versions or service types, you will have to specify the name of the SQL instance when connecting rather than just using the server’s name or IP. If you have created a named instance, you will need to access it by appending the name to the server’s name or IP, following a backslash (e.g. 12.34.56.78\SQLINSTANCENAME or SQLSERVERNAME\SQLINSTANCENAME).