#1 2023-05-20 07:41:31

west07
Member
Registered: 2023-05-20

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.".)

Offline

#2 2023-05-20 19:58:46

west07
Member
Registered: 2023-05-20

Re: error connecting database SQL Server express

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)

Offline

#3 2023-05-22 15:15:08

eduardo
Administrator
Registered: 2016-11-01
Website

Re: error connecting database SQL Server express

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/ … -p/2591304

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB