Profile picture for user TRW_Asiatic

Hello Community,

As some of you already know, I have used ARIS MashZone with a MS Access Database so far.

Anyway, the MS Access DB will be replaced with a connection to the existing MS SQL Server DB.

But I'm facing some problems while setting up the database in ARIS MashZone.

From the beginning:

1) SQL Server is running

2) System DSN is created on the local laptop --> Data Source Connection Test to DB works.

3) The MS SQL Server JDBC 3.0 Driver is loaded and the file "sqljdbc4.jar" is placed in the folder ARIS MashZone/jdbcdrivers

4) In the administration view of MashZone, I've made the settings as below:

After I press "test  database connection", and enter the user credentials, I get the following message (in german):



At present, I don't know where I need to make any changes in the settings. A SQL Server Instance is of course running and active.

Any ideas folks? Any help is appreciated :-)

by Markus L. Author
Posted on Sun, 05/29/2011 - 08:26

Additional question: 

Apart from the steps I haven taken above, do I need to edit/modify any other files or settings? Do I need to modify the "sqljdbc4.jar" file in any way?

by Markus L. Author
Posted on Mon, 05/30/2011 - 11:03


I got it to work with the already implemented JDBC-ODCB bridge, but it still does not work with the sqljdbc4 driver. Nobody has an idea?

by Markus L. Author
Posted on Mon, 05/30/2011 - 12:47

Actually I'm wondering how the 189 viewers connect their ARIS MashZone to a database... or do you guys just use DB2? :-P

by Stephan Freudl
Posted on Tue, 05/31/2011 - 08:43

Hi Markus,

the steps you describe in your original post are perfectly ok. The error message indicates that your computer cannot communicate with the database server. This raises two questions:

  1. Is your operating system's language German? The German part of the message comes out of the JDBC driver implementation provided by Microsoft.
  2. On which computer is the MS SQL Server running?

    Your JDBC URL points to localhost, i.e. the machine where MashZone is installed. If this is true, please verify that the database runs on port 1443 (which MS SQL's default) and no firewall blocks this one.

Of course you could continue using the ODBC bridge but each vendor doesn't recommend to do so. Please note: When you use the ODBC bridge your JDBC URL points to localhost, always. Refer to your ODBC settings to find out the database's host and port name.



by Markus L. Author
Posted on Tue, 05/31/2011 - 10:08

Dear Stephen,

I got it to work... it's so strange, when I checked the SQL Server Configuration Manager, I couldn't believe what I saw there:

The TCP/IP protocol was disabled by default!! :-O

I did a clean install of SQL Server Express 2008, created a simple demo database. Why is the TCP/IP protocol disabled by default? That shouldn't happen.

Now the connection between ARIS MashZone and SQL Server works just fine.

Thank you very much for your advice! Kudos to you ;-)


Featured achievement

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


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