ARIS MashZone and SQL Server setup -> connection error

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?

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?

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

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.

Regards

Stephan

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