Skip to content

Instantly share code, notes, and snippets.

@deependhamecha
Last active September 27, 2021 10:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save deependhamecha/b7bdfd740bd962475a4951ea6e54926e to your computer and use it in GitHub Desktop.
Save deependhamecha/b7bdfd740bd962475a4951ea6e54926e to your computer and use it in GitHub Desktop.
MS SQL Windows Based Authentication JDBC

type hostname and you will get your domain

application.properties

spring.datasource.url=jdbc:sqlserver://localhost;databaseName=DWIDDER2DB;domain=DESKTOP-2J92742;integratedSecurity=true;authenticationScheme=NTLM
spring.datasource.username=deepen
spring.datasource.password=abcd
spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2013Dialect
spring.jpa.show-sql=true

Remember, to put authenticationScheme

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment