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"
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
0
27.5k
4
by Runé Becker
Posted on Mon, 05/13/2013 - 19:19
Dear Robin,
How to connect MashZone with Microsoft SQL Server has been already discussed here:
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:
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 :(.
