spring - 无法获得 JDBC 连接；嵌套异常是 com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user

Question

这是我的应用程序 .properties 文件

server.context-path=/moneymonster
management.security.enabled=false

#spring.datasource.url=jdbc:mysql://localhost:3306/money_monster?zeroDateTimeBehavior=convertToNull&createDatabaseIfNotExist=true
spring.datasource.url=jdbc:sqlserver://localhost:1433;databaseName=projej30521
spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.username=
spring.datasource.password=

#Jpa
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect

#batch
spring.batch.job.enabled=false

#security.user.password=password

#jsp
spring.mvc.view.prefix: /view/
spring.mvc.view.suffix: .jsp

application.propeties 文件由 hibernate 和 jpa 的配置以及 sql server 12 配置组成

标签： springspring-bootsql-server-2012

Answer 1

spring.datasource.username= "you must set username"

如果你有密码，你必须设置它

这个例子

spring.datasource.url=jdbc:sqlserver://localhost;databaseName=springbootdb
spring.datasource.username=sa
spring.datasource.password=Projects@123
spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.jpa.show-sql=true
spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect
spring.jpa.hibernate.ddl-auto = create-drop