记一次Springboot1.5.X整合Mysql转SqlSer

1.数据源配置修改

<!--sqlserver-->
<dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <scope>runtime</scope>
</dependency>

修改依赖.png

spring:
  application:
    name: spring-cloud-consumer
  datasource:
    name: demo
    url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=demo
    username: sa
    password: 123456
    #使用druid数据源
    type: com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver

数据源配置修改.png

2.启用协议

启用协议.png

3.重启SqlServer