Jump to content

BIRT Developer Center Download


Photo
- - - - -

connect to SQL Server using Windows Authentication?


  • Please log in to reply
2 replies to this topic

#1 a259746

a259746

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 25 October 2011 - 05:13 AM

I am using e.spreadsheet v9sp3 Need to connect to a SQL Server with an ID that is set up to only connect using WINDOWS AUTHENTICATION. I am able to connect perfectly fine to another SQL db that allows SQL Authentication. Please help me with the Driver, Driver Class, Database URL and any drivers or CLASS files i may need to install/save to my PC. Thanks in advance.

#2 blagerweij

blagerweij

    Junior Member

  • Members
  • Pip
  • 5 posts

Posted 08 February 2012 - 03:46 PM

I am using e.spreadsheet v9sp3
Need to connect to a SQL Server with an ID that is set up to only connect using WINDOWS AUTHENTICATION.
I am able to connect perfectly fine to another SQL db that allows SQL Authentication.
Please help me with the Driver, Driver Class, Database URL and any drivers or CLASS files i may need to install/save to my PC. Thanks in advance.


Using Microsoft JDBC:
jdbc:sqlserver://localhost;integratedSecurity=true;
(make sure you add the sqljdc_auth.dll on the java.library.path)


Using open source jTDS:
jdbc:jtds:sqlserver://localhost/dbname;domain=MYDOM
Leave username and password blank, add ntlmauth.dll to java.library.path; see README.SSO in the distribution

Kind regards,

Barry Lagerweij

#3 Vijendrashukla4

Vijendrashukla4

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 19 April 2017 - 02:57 AM

Hi Barry Lagerweij,
 
We are using below configuration 

 

 

configuration

*******************

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<DataTools.ServerProfiles version="1.0">
<profile autoconnect="No" desc="" id="d5caf390-8559-11e6-9a49-92bbe09517d9" name="SQL_Connection" providerID="org.eclipse.birt.report.data.oda.jdbc">
<baseproperties>
<property name="odaURL" value="jdbc:actuate:sqlserver://LOCALHOST:1433;databasename=TEST_DB1"/>
<property name="odaDriverClass" value="com.actuate.jdbc.sqlserver.SQLServerDriver"/>
<property name="odaPassword" value="TEST123"/>
<property name="odaUser" value="sa"/>
<property name="contentBidiFormatStr" value="ILYNN"/>
<property name="metadataBidiFormatStr" value="ILYNN"/>
</baseproperties>
</profile>
</DataTools.ServerProfiles>

 

 

and we are unable to figure-out how to change the below config to WINDOWS authentication, 

 

we have are using the jtds1.3.1.jar jar along with ntlmauth.dll dll file and the jtds connection string with driver file mentioned below.

 

jtds connection string we are using

******************************************

 

jdbc:jtds:sqlserver://LOCALHOST:1433/TEST_DB1;userCursors=true

 

jdbcDriver
*****************
net.sourceforge.jtds.jdbc.Driver
 
 
 jdbcDriverXAClass
************************
com.microsoft.sqlserver.jdbc.SQLServerXADataSource
 
 
The confusion is by the providerID="org.eclipse.birt.report.data.oda.jdbc" which is eclipse jar file.
 
Request you to please help us thank you.

 

Thank you,

 

Thanks & Regards,

VS