Can I connect to SQL Server using Windows Authentication from Java EE webapp?

by

I do not think one can push the user credentials from the browser to the database (and does it makes sense ? I think not)

But if you want to use the credentials of the user running Tomcat to connect to SQL Server then you can use Microsoft’s JDBC Driver.
Just build your JDBC URL like this:

jdbc:sqlserver://localhost;integratedSecurity=true;

And copy the appropriate DLL to Tomcat’s bin directory (sqljdbc_auth.dll provided with the driver)

MSDN > Connecting to SQL Server with the JDBC Driver > Building the Connection URL

More Related Contents:

  1. Native Library sqljdbc_auth.dll already loaded in another classloader
  2. To prevent a memory leak, the JDBC Driver has been forcibly unregistered
  3. MySQL JDBC Driver 5.1.33 – Time Zone Issue
  4. JDBC connection failed, error: TCP/IP connection to host failed
  5. What does Statement.setFetchSize(nSize) method really do in SQL Server JDBC driver?
  6. java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
  7. Where are compiled JSP Java (*__jsp.java) files?
  8. Any way to share session state between different applications in tomcat?
  9. How do I connect to a SQL Server 2008 database using JDBC?
  10. JPA SQL Server No Dialect mapping for JDBC type: -9
  11. Stop scheduled timer when shutdown tomcat [duplicate]
  12. Get the server port number from tomcat without a request
  13. Tomcat vs Weblogic JNDI Lookup
  14. Driver.getConnection hangs using SQLServer driver and Java 1.6.0_29
  15. Embedded tomcat 7 servlet 3.0 annotations not working
  16. Is there a way to run a method/class only on Tomcat/Wildfly/Glassfish startup?
  17. is there a standard way to define a JDBC Datasource for Java EE containers?
  18. JDBC SQLServerException: “This driver is not configured for integrated authentication.”
  19. Using .html files as JSPs
  20. Where do I have to place the JDBC driver for Tomcat’s connection pool?
  21. How to get *everything* back from a stored procedure using JDBC
  22. Besides EAR and EJB, what do I get from a Java EE app server that I don’t get in a servlet container like Tomcat?
  23. no sqljdbc_auth in java.library.path
  24. Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
  25. How to deploy a Java Web Application (.war) on tomcat?
  26. How to store a file on a server(web container) through a Java EE web application?
  27. Proper usage of JDBC Connection Pool (Glassfish)
  28. The TCP/IP connection to the host localhost, port 1433 has failed
  29. Which technologies does Tomcat support?
  30. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR

Leave a Comment