error connecting database SQL Server express

Hello,

I have the following error, could you help me to solve it?
It is the configuration in windows server with SQL server express, the ports are open correctly I don’t know what is missing

As for the data you know, which is the user that should go and password?

_
Connection Test: Failed (The TCP/IP connection to the host localhost, port 1433 has failed. Error: “Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.)
_

The complete sequence is:

ReportServer encountered an error while validating its environment. Please check the server log files for additional information.


| __ \ | | / |
| |) |
_ __ ___ _ __| |
| (
_ ___ _ ____ _____ _ __
| _ // _ \ '_ \ / _ | '| |_ \ / _ \ '\ \ / / _ \ '|
| | \ \ / |) | () | | | | ___) | __/ | \ V / __/ |
|
| __
| .
/ _/|| _|/ _|_| _/ _||
| |
|
|

Version: RS4.5.0-6089 2023-05-19-14-35-35
Code Version: 2023-04-03-12-41-54
Java Version: Azul Systems, Inc. OpenJDK 64-Bit Server VM 11.0.19+7-LTS (11)
VM Args: -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 9.0 -Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 9.0 -Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat 9.0\temp -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=C:\Program Files\Apache Software Foundation\Tomcat 9.0\conf\logging.properties -Drs.configdir=C:\Program Files\reportserver -Dfile.encoding=UTF8 --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED exit abort -Xms512m -Xmx1500m
Max memory: 1.46 GB
Groovy Version: 4.0.12
JVM Locale: en_US
JVM user language: en
JVM user country: US
JVM user timezone: UTC
JVM file encoding: UTF8
JVM server time: 2023-05-20T07:12:37.2265678Z[UTC]
Operation system: Windows Server 2019 10.0 (amd64)
rs.configdir: C:\Program Files\reportserver (OK)

DB Config

hibernate.dialect: net.datenwerke.rs.utils.hibernate.SQLServer2008Dialect (OK)
hibernate.connection.driver_class: com.microsoft.sqlserver.jdbc.SQLServerDriver (OK)
hibernate.connection.url: jdbc:sqlserver://localhost;databaseName=reportserver (OK)
hibernate.connection.username: root
hibernate.default_schema:

Connection Test: Failed (The TCP/IP connection to the host localhost, port 1433 has failed. Error: “Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.)

Fixed the previous one, now this one is presented:

Connection Test: Failed (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target”. ClientConnectionId:59a00881-0e2f-4fa8-8ba9-061e2e46c6ec)

Hi west07,

pls try to use trustServerCertificate=false; in your JDBC url if not intending to use encryption.
Otherwise, pls refer to https://techcommunity.microsoft.com/t5/azure-database-support-blog/pkix-path-building-failed-unable-to-find-valid-certification/ba-p/2591304

Regards,
Eduardo