CANNOT Connect with Multi-Site 64 bit MS-SQL to MS-SQL DB 2008 R2

[tadhg]

CANNOT Connect with Multi-Site 64 bit MS-SQL to MS-SQL DB 2008 R2

keep getting No suitable driver found for jdbc:jtds:sqlserve:/X.X.X.:1433/DatabaseName

and also not to forget Unable to detect database version.Tried version {MS SQL Sefver 2005/2008/2012 ERROR:No suitable driver......

[kreed7]

MSSQL JDBC: http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx

MySQL JDBC: MySQL :: Download Connector/J

(you need to locate the .jar file from the above install)

Have you placed the correct JDBC .jar file in $smartconnector_home/current/user/agent/lib/ folder?

[rakesh.mukherje]

Yes, JDBC (v.4) driver could be an issue also use the most recent version of SmartConnector agent.

[tadhg]

A mysql driver will work for MS-SQL db?

[tadhg]

Does 7.0.3.X not have this issue?

[kreed7]

Tim,

I apologize I misread. Use a MSSQL driver.

Below is where you can download the MSSQL driver.

http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx

Sometimes my eyes get a little crossed.

I have attached the mssql driver I am using.

-Edit-

The Url I used looks like this:

jdbc:sqlserver://FQDN:PORT;DatabaseName=DB

[BKarpinski]

Having the same issue. We are suspecting a permissions issue with the DB account we are using?

[Vini]

If running on windows you will have to use integrated authentication and run the connector as the user that you are using to connect to the db.

There have also been some issues with java that broke the MSSQL driver, I struggled with it for a while just to find out that I had to use an older version of java. I don't have the version here to post now.

[BKarpinski]

Our issue has been resolved. We found that encryption was enabled on the db which was resetting our connection when trying to verify database version.