How to access SQL Server database from iccube builder

Question

I am trying to connect to SQL server from iccube Web UI, but when I set up the Data Source connection like this

Name: TestDataBase
DriverType: SQL Server
ServerName: localhost
DB Name: TestDataBase

User: MyWindowsUserName
Password: ********** 

(my windows username and password).

, I got the following error:

JDBC connection for url 'jdbc:sqlserver://localhost:1433;databaseName=TestDataBase;' and user 'MyWindowsUsername' cannot be created due to error 'Login failed for user 'MyWindowsUsername'.

What am I missing, and can I somehow use integratedSecurity so I can login with my windows credentials as I do from SQL Server Management studio.

Answer 1

You can try to setup the connection string as mentionned by Hermes (or here) using the "Server Name" and "DB Name" to define the actual JDBC class name and connection string (check the help icons closed to each fields):

Hope that helps.