How to connect to ms sql server?

Question

Java

Hello I am having some difficulty connecting to ms sql from my spring boot application.
I downloaded and installed ms sql and management studio created a table in it and now I want to display data from it on a web page.
in the property i put this :

# ===============================
# DATABASE CONNECTION
# ============== =================
spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.url=jdbc:sqlserver://localhost; databaseName=Test
spring.datasource.username=mssql
spring.datasource.password=mssql

with the data from here (I made the password the same as the login name)

but when I try to run the application I get an error

com.microsoft.sqlserver.jdbc.SQLServerException: A TCP/IP connection could not be established to server localhost on port 1433. Error: "Connection refused: connect. Check connection properties.

although everything seems to be correct, what did I do wrong or what did I not do?

Answer 1

Check if it is enabled and activated ( two settings) for you TCP/IP.
Find where SQLServerManager*.mscand run.
The command where SQLServerManager*.mscis the search. The default file should be in C:\Windows\System32. Must be in all editions, it is impossible to disable the installation.

Answer 2

What is the mssql account type? Windows or SQL?

jdbc:sqlserver://localhost;instanceName=SQLEXPRESS;DatabaseName=test;integratedSecurity=true