how to configure JDBC Adapter for SQLServer 2008

Guest · April 30, 2012, 12:31pm

Hi All,

I would like to know whether I am giving proper information when setting up JDBC connection to SQL Server.

I have copied the jar files msutil.jar, msbase.jar and mssqlserver.jar under …/IntegrationServer/packages/WmJDBCAdapter/code/jars/static/ and restarted the server.

Other than the above jar files, do i need to install any other jars?

In the connection details, I am using datasource class as com.microsoft.jdbcx.sqlserver.SQLServerDataSource and providing servername, databasename, userid, pw, port,

What should i mention in Network Protocal and OtherProperties? Please let me know.

Best Regards,
david.

Guest · April 30, 2012, 9:41pm

I’m getting the following error:

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Connections.jdbc:Test1.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection Connections.jdbc:Test1: after 1 attempt(s).
[ADA.1.204] Cannot connect to the database with DataSource class “com.microsoft.jdbcx.sqlserver.SQLServerDataSource”.
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user ‘ABCD’.

Guest · May 1, 2012, 9:22pm

Any help, please let me know. I’m still getting the same error. The server is SQL Server 2008 R2.( I given wrong info…in my original thread)

rakon · May 2, 2012, 2:31am

Can you check whether you are using the proper drivers for SQL Server 2008. your error log says “SQLServer 2000 Driver for JDBC”

Guest · May 2, 2012, 8:31am

Yes. The drivers are proper. I have msbase.jar, msutil.jar and mssqlserver.jar under /static/ folder.

Now, I have changed the datasource class to: com.microsoft.sqlserver.jdbc.SQLServerDataSource. Now, I am getting the below error.

[ADA.1.204] Cannot connect to the database with DataSource class “com.microsoft.sqlserver.jdbc.SQLServerDataSource”.
Login failed for user ‘ABCD’.

What should i give in the datasource class? how can i determine what to use in this field. Any inputs are much appreciated.

shahid2 · May 2, 2012, 10:43am

Check if credentials are correct…

Guest · May 3, 2012, 12:45am

The credentials are correct as well. But still getting cannot login error.

Guest · May 3, 2012, 6:21pm

Here are the connection details again. The server is SQL Server 2008 R2.

TransactionType: LOCAL_TRANSACTION
DataSource Class: com.microsoft.sqlserver.jdbc.SQLServerDataSource
Servername: abcdefgh
port: 2866
user: ABCD
pw: ****
database: test
networkProtocal: TCP
Other Properties: Left blank.

Did not enable: connection Pooling [ I would like to enable after the connection is setup ]

The jar files which are already in place are msbase.jar, msutil.jar, mssqlserver.jar and sqljdbc.jar under /IntegrationServer/packages/WmJDBCAdapter/code/jars/static/

and sl53_cj34.jar under IntegrationServer/lib/jars/.

But I still get the same error as above. Can someone let me know what might be missing. Is it the login credentials or any jar file missing?

vanya · June 11, 2012, 10:20am

Hello David,

I am getting the same error as above.

Can you please let me know how you resolved it!

Thanks in advance…

Senthilkumar_G · June 11, 2012, 12:11pm

If it is Login failed error, make sure you are using the correct user name and password to login. You can paste the exact error message you are getting…

-Senthil

kumar_kambhampati1 · June 10, 2015, 6:06pm

I’m getting the below error, when im trying to connect to SQL Server 2008. We are using wM 9.7

[ADA.1.204] Cannot connect to the database with DataSource class “com.microsoft.sqlserver.jdbc.SQLServerDataSource”.
SQL Server version 8 is not supported by this driver.

Any quick help is really appreciated.

Holger_von_Thomsen · June 10, 2015, 6:27pm

Please check for latest Driver from Microsoft (Version 4.1.5605.100 or newer).

Alternatively you can try to use the embedded DataDirect-Driver (common/llib/ext/dd-cjdbc.jar).
See Settings->JDBC-Pools for a Sample how the Connection can be configured.

Regards,
Holger

Mahesh_K_Sreenivas · June 10, 2015, 6:31pm

Do you have sqljdbc4.jar placed in the below locations: Restart IS

<SAG_HOME>\IntegrationServer\packages\WmJDBCAdapter\code\jars\
<SAG_HOME>\IntegrationServer\packages\WmJDBCAdapter\code\jars\static\
<SAG_HOME>\IntegrationServer\lib\jars

kumar_kambhampati1 · June 10, 2015, 9:28pm

*************Issue Resolved *************

I have installed these jar files and gave the properties below:

The jar files required:

mssqlserver.jar
msbase.jar
msutil.jar

Copy the jar files and place them in \instances\default\packages\WmJDBCAdapter\code\jars\static

Transaction Type LOCAL_TRANSACTION
Data Source Class: com.microsoft.jdbcx.sqlserver.SQLServerDataSource
serverName : XYZ.com
user : XYZ
password : ****
databaseName
portNumber :1433
networkProtocol
Other Properties
Connection Management Properties
Enable Connection Pooling false

CONNECTION ENABLED SUCCESSFULLY.

Kumar_Kambhampati3 · June 10, 2015, 10:49pm

Correction: Copy all the jar files to \instances\default\lib\jars

Muhammad_Tayyab · June 10, 2018, 1:09pm

i am getting the same error while setting up sql connection, any one can help?

Muhammad_Tayyab · June 10, 2018, 1:17pm

i am getting this exact error “Connection refused (Connection refused). Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port”

Gerardo_Lisboa · June 11, 2018, 8:25am

Hi,

Check if that user is allowed to do a remote login.
Use another DB client from your PC to check (SQuirreL, Database Browser, etc.).

Is it a DB user or an AD user? In the later case you need to configure other properties.

Maybe you also need to add the “instance=instance_name” parameter on Other Properties.

Best regards,