ARIS MashZone and SQL Server setup -> connection error

Posted by Markus L.

Posted on Fri, 05/27/2011 - 13:05 in MashZone

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 :-)

28.2k

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

Update:

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:

Is your operating system's language German? The German part of the message comes out of the JDBC driver implementation provided by Microsoft.
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.

Regards

Stephan

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 ;-)