iman.gharib Posted June 15, 2016 Share Posted June 15, 2016 How connect to a ms SQL server using windows authentication in jasperstudio without having jasper server? All the tutorials that I have found are declaring the connection between a ms SQL server and jasper server. But need to set my data adapter so that I can connect to the SQL server from jasperstudio using windows authentication Link to comment Share on other sites More sharing options...
hozawa Posted June 15, 2016 Share Posted June 15, 2016 The steps required are the same as with setting up for a server. You just need to specify the jdbc driver and url string to the database.In the Data Adapter Wizard,there is a "Driver Classpath" tab at the bottom (default tab is "Database Location". Just press "Add" and select sql server jdbc driver. The settings required on sql server is the same as for setting up for JasperReports Server connection. Link to comment Share on other sites More sharing options...
Solution iman.gharib Posted June 16, 2016 Author Solution Share Posted June 16, 2016 I had connection error until I followed this link: http://community.jaspersoft.com/questions/951061/sql-server-connection-integrated-authentication-jaspersoft-studio Link to comment Share on other sites More sharing options...
hozawa Posted June 16, 2016 Share Posted June 16, 2016 My bad.To think of it, I may have done some different. Have you tried the solution offered below?http://stackoverflow.com/questions/12304495/solve-error-in-connection-between-sql-server-2008-r2-with-java-in-eclipse I usually set Jaspersoft Studio to use my local version of Java that I've installed and I may have added the files to Java's lib folder.(Edit Jaspersoft Studio.ini file and change "-vm" to local Java directory.) Link to comment Share on other sites More sharing options...
iman.gharib Posted June 16, 2016 Author Share Posted June 16, 2016 It did not work in my case using the default java settings of jasperstudio. But the link is informative. thanks Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now