ReportServer Forum

richardlrz

Member

Registered: 2020-12-20

Manual install RS3.3.0 with Postgres DB failed with Connection Test

Hello I am the new bee for RS, and I am try to setup Report Server with Postgres DB on windows 10 VM
Version of the RS:  RS3.3.0-6030 2020-09-25-11-16-41
PostgresSQL13
I followed the best practice for the Installing ReportServer on Windows as well as 2.2. Manual Installation to setup the JRE, database and RS zip package.
I have no problem to login the database from pgAdmin4 and I did even test from psql, I have no problem to connect with reportserver and all tables created by the reportserver-RS3.3.0-6030-schema-PostgreSQL_CREATE.sql. after I setup everything, I browser to 127.0.0.1:8080/ReportServer.html   I got:

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

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

Version: RS3.3.0-6030 2020-09-25-11-16-41
Code Version: 2020-09-25-10-02-31
Java Version: Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 25.271-b09 (1.8)
VM Args: -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 8.5 -Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 8.5 -Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat 8.5\temp -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=C:\Program Files\Apache Software Foundation\Tomcat 8.5\conf\logging.properties -Drs.configdir=C:\Program Files\reportserver -Dfile.encoding=UTF8 exit abort -Xms512m -Xmx2048m
rs.configdir: C:\Program Files\reportserver (OK)

### DB Config ###
hibernate.dialect: org.hibernate.dialect.PostgreSQLDialect (OK)
hibernate.connection.driver_class: org.postgresql.Driver (OK)
hibernate.connection.url: jdbc:postgresql://localhost/reportserver  (OK)
hibernate.connection.username: postgres
hibernate.connection.password: **********
hibernate.default_schema:

Connection Test: Failed (FATAL: database "reportserver " does not exist)

Any ideaof how to fix this?

Thanks

Richard

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Manual install RS3.3.0 with Postgres DB failed with Connection Test

Hi Richard,

I answered here. https://forum.reportserver.net/viewtopic.php?pid=8383
Pls don't create double postings.

Regards,
Eduardo