CODEWITHSUNDEEP
iccube
vldmrrdjcc
vldmrrdjcc

Reputation: 2112

How to access SQL Server database from iccube builder

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.

Upvotes: 1

Views: 145

Answers (2)

Marc Polizzi
Marc Polizzi

Reputation: 9375

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):

enter image description here

Hope that helps.

Upvotes: 1

Hermes
Hermes

Reputation: 33

Try jdbc:sqlserver://localhost:1433;databaseName=TestDataBase;integratedSecurity=true;

Upvotes: 1

Related Questions