Spago BI SQL Server connection

Hi,
I have downloaded and used SpagoBI All In One 5.2 and I like it. Now, I want to connect to an MS SQL Server. I have done some research and found out that I have to download the Microsoft JDBC Driver 4.0 for SQL Server....but do not know which path/directory to place the file(s) in.

There are two files in that package. sqljdbc.jar and sqljdbc4.jar

Next, what is the connection string? Sorry, I am not at that computer right now so don't remember the exact term its looking for.....

Step by step would be nice :)

Thanks!

This message was edited 1 time. Last update was at 18/01/2017 02:30:41

Hi,
The conection string have the next sintax:
jdbc:sqlserver://IP : PORT;databaseName=DB_NAME

The PATH for the JDBC Driver 4.0 is
All-In-One-SpagoBI-5.2.0_11042016\All-In-One-SpagoBI-5.2.0\lib

you should errease the other version (sqljdbc.jar) for this directory and resart SpagoBI Server

This message was edited 1 time. Last update was at 22/03/2017 16:35:14

Hello, I have sqljdbc42, this serves? When will big forehead an error connection driver path " com.microsoft.sqlserver.jdbc.SQLServerDriver"
can you help me, I don't know what else to do

This message was edited 1 time. Last update was at 30/04/2017 18:41:27

I have the same issue in connecting to MSSQL
My settings are
jdbc:sqlserver://DESKTOP-0D5EHEU;databaseName=dbname
Driver - com.microsoft.sqlserver.jdbc.SQLServerDriver

Installed the driver sqljdbc42 in F:\Spagobi\All-In-One-SpagoBI-5.2.0\lib folder.

Getting error as
[http-bio-8080-exec-9] 30 Apr 2017 22:02:43,875 ERROR it.eng.spagobi.tools.datasource.service.rest.TestConnection.testDataSource:105 - Error testing datasources
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

'2017-04-30-22-02-43';'0:0:0:0:0:0:0:1';'0:0:0:0:0:0:0:1';'0:0:0:0:0:0:0:1';'';'';'';'biadmin';'/spagobi/admin,';'[Service:/datasources/test ; Class:class java.lang.String]';'biadmin';'/SpagoBI/restful-services/datasources/test';'DATASOURCE_ID=[7]&CONNECTION_URL=[ jdbc:sqlserver://DESKTOP-0D5EHEU;databaseName=dbname]&DRIVER=[com.microsoft.sqlserver.jdbc.SQLServerDriver ]&SBI_EXECUTION_ID=[-1]&USER=[sa]&JNDI_URL=[]&READ_ONLY=[false]&READ_WRITE=[readwrite]&PASSWORD=[smith]&DESCRIPTION=[MSSQL]&DIALECT_ID=[63]&SCHEMA=[]&DATASOURCE_LABEL=[MSSQL]&TYPE=[jdbc]&WRITE_DEFAULT=[false]';'OK';'0';'FIREFOX';'53.0';'WINDOWS';5b75f79b0893bf1eccc8a8ed37804e31

Thanks in advance