MS SQL DB Connection Issue

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

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>...

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

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

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

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