Connection MASHZONE to Microsoft SQL Database

robin smits on May 13, 2013

Hello ARIS Community,

I have a question about the connection between mashzone and the msql database. My ARIS Business Server has a connection via the opensource driver: "jtds-1.3.0.jar"

Settings in config:

url=jdbc\:jtds\:sqlserver\://<<PCNAME>>\:<<PORT>>/Aris71;instance\=<<INSTANCENAME>>

driver=net.sourceforge.jtds.jdbc.Driver this connection between Business Server and the MSQL works fine. Now I want to connect mashzone with the aris database. First of all the driver "jtds-1.3.0.jar" is not regonized when I put it in the location %MASHZONE_HOME%\jdbcdrivers.Is this opensource driver not supported for mashzone? so i tried to use the "sqljdbc4.jar" but now i need a other url because it is not the "jtds". In the manual it says: url=jdbc\:sqlserver\://<host>\:<Port>;DatabaseName\=ARIS71 driver=com.microsoft.sqlserver.jdbc.SQLServerDriver However the settings above do not work, maybe it's because I am missing the instance settings. Is there anyone that can help me out, or point me in the right direction. Thanks in advance. Greetings Robin

Sign in or register to reply.

Notify Moderator

4 Replies

Runé Becker on May 13, 2013

Dear Robin,

How to connect MashZone with Microsoft SQL Server has been already discussed here:

http://www.ariscommunity.com/users/trwasiatic/2011-05-27-aris-mashzone-and-sql-server-error-message

And how to connect MashZone with ARIS Business Server is available here:

http://www.ariscommunity.com/users/stephan-freudl/2010-09-27-hd-video-aris-mashzone-20-connects-aris

If either one doesn't help, maybe someone else could help out. Anyway the concrete error message you receive would help.

Cheers

Rune

Like

Sign in
or register to reply.

Notify Moderator
robin smits on May 14, 2013

thanks for you quick reply. i seen the blogs, the scheduled reports works.

this is the error i am currently getting:

The following error occurred when connecting to database "ARIS71": The TCP/IP connection to the host WIN-KA439T9RIRC, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

i checked the tcp ip settings in the SQL Studio Manager it is enabled. also i turned off the firewall to excluded that problem. I tryed different urls:

jdbc:sqlserver://WIN-KA439T9RIRC:1433;databaseName=Demo;instance=SQLEXPRESS

jdbc:sqlserver://WIN-KA439T9RIRC:1433;databaseName=Demo

Like

Sign in
or register to reply.

Notify Moderator
Thomas Metzger on May 16, 2013

Hi Robin,

I have been using sqljdbc4.jar as well;

so when using com.microsoft.sqlserver.jdbc.SQLServerDriver I use URLs like

jdbc:sqlserver://HOST:1433;databaseName=DATABASE

- so your approaches should be fine

maybe:

- try IP instead of hostname

- check database name (Demo vs. ARIS71)

- make sure you use a technical user for authentication (windows authentication causes a lot of trouble)

- check once again your network infrastructure SQL Server - MashZone

Like

Sign in
or register to reply.

Notify Moderator
robin smits on May 17, 2013

it worked with the string "jdbc:sqlserver://HOST:1433;databaseName=DATABASE", also the string jdbc:sqlserver://WIN-HOST:1433;instance=INSTANCE;databaseName=DATABASE. It turned out there was a other program that used the port 1433, thats why my connection from mashzone got blocked :(.

Thanks for your help.

Like

Sign in
or register to reply.

Notify Moderator

There are currently no upcoming events.

Sign in

Reset Password