You are not logged in.
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
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
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