msaiz

Yes - I read that too and installed "Microsoft JDBC Driver 4.2 for SQL Server" on my system. Still getting the same error.

If I use "=SSPI", I get the error that only "True" or "False" are valid.

is this what you mean? jdbc:sqlserver://USC1DDB64BDEV;databaseName=StJudeMedical_82_DW;integratedSecurity=true; If so, this is the error:

I am New to JS Studio and attempting to connect to MS SQL DB from Jaspersoft Studio. But I get the followign error: net.sf.jasperreports.engine.JRException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'SJMsaizm01'. ClientConnectionId:ee7f330c-a14a-46db-a1c8-ee0b2ad9ccafat net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:130)at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:128)at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:162)at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:59)at java.lang.Thread.run(Unknown Source)Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'SJMsaizm01'. ClientConnectionId:ee7f330c-a14a-46db-a1c8-ee0b2ad9ccafat com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908)at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:168)at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:128)... 4 more Our DBA's tell me that we use “Windows authentication”, but that option is not available. How do I resolve this?