PG

Hi We are using MS SQL server as database and wanted to create a db connection.

But we are receiving the below error when creating the connection:

 

The following error occurred when connecting to database "XXX dev": No suitable driver found for jdbc:wm:sqlserver://192.XXX.XXX.XX:52567;databaseName=xxx_wm_db;userName=xxx_wm_admin;password=xxxxx@123 

 

We have already placed sqljdbc4.jar in /opt/ARIS_MashZone/jdbcdrivers/ directory.

We have restarted the mashzone also. 

We can see the below driver in connections page in Aris Mashzone :

com.microsoft.sqlserver.jdbc.SQLServerDriver

 

 

by Prasad Gandhavalla Author
Posted on Wed, 02/13/2013 - 15:23

Could you please let us know how to change the DB driver?

0
by Helmut Barro
Posted on Thu, 02/14/2013 - 08:02

The DB driver is correct, what looks wrong to me is the URL you're using.

 

Please try the following syntax (please note especially the removed "wm" part):

jdbc:sqlserver://<databasehostname>:<port>;selectMethod=cursor;databaseName=<databasename>...

0
by Amol Patil
Posted on Thu, 02/14/2013 - 08:25

Hi Prasad,

There is no need to specify the UserName and Password in the URL. Please correct the url as Helmut suggested.

Earlier, we faced the same problem. There were two drivers in "ARIS_MashZone/jdbcdrivers/" directory "sqljdbc.jar" and the one we placed "sqljdbc4.jar". So on the driver selection page, there was some conflict in selecting the right driver, as both have the same name "com.microsoft.sqlserver.jdbc.SQLServerDriver".

We removed the older one "sqljdbc.jar", and re-configured the connection. It solved this problem.

Regards,

Amol Patil

0
by Vassiliki Spentzou
Posted on Fri, 12/19/2014 - 11:58

In reply to by Amol

Dear Amol

When you say you removed the older driver jar do you imply you did this through your Windows Explorer or through ARIS Cloud Controller? 

Thank you in advance

0
by Klaus Schulz
Posted on Wed, 02/20/2013 - 17:23

Hi,

I am not sure if I am right here, but I have a similar issue to connect to the MSSQL database (Business Server). We changed the local user to a domain user "domain\user". The error message is "cannot connect to SQL Server, SQL state was S0001, error message was: Login failed for user 'DomainUser'." You can see that the "\" was removed.

Thoughts?

Klaus

0
by Amol Patil
Posted on Tue, 12/23/2014 - 07:17

Hi Vassiliki,

The above procedure mentioned is for ARIS 7.2. I have not checked it for ARIS 9 versions. Please check the folder through windows explorer "ARIS_MashZone/jdbcdrivers/" and ensure that there is only one driver jar file. The path may be different in case of ARIS 9.

 

Hi Klaus,

"\" is considered as escape character. Please try using "\\" or "/" in the config. If it fails, please take help from DBA to configure the url with windows authentication.

 

Regards,

Amol Patil

 

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock