I've just installed 8.2 pentaho server ce and I'd like to configure a Datasource that read data from my SQL Server Database.
I need to connect to the dbms using sql server integrated authentication, that I successfully used using pentaho Data Integration, but in this case I can't select an MS SQL Server (native) or an MS SQL Server because anyone of two doesn't exist.
I tried using a connection string like this jdbc:sqlserver://MYSQLSERVERNAME:1433;integratedSecurity=true;databaseName=MYDBNAME;
as connection string and com.microsoft.sqlserver.jdbc.SQLServerDriver as Custom Driver Class Name (I positioned mssql-jdbc-7.0.0.jre8.jar in C:\pentaho-server-ce-126.96.36.199-342\tomcat\lib) but I hadn't success.
Have I any other method to follow?