What is needed for Reports Server (CE) if the database moves to a different host?

[andrew_50]

We're looking like we will be moving our database to a different host.
Does that affect Reports Server? If so, how?

Essentially, is there a simple tweak to accomplish this switch?
Or am I looking at a re-install?

[shreekrishna.shankhwar]

On 4/26/2024 at 11:27 PM, andrew_50 said:

We're looking like we will be moving our database to a different host.
Does that affect Reports Server? If so, how?

Essentially, is there a simple tweak to accomplish this switch?
Or am I looking at a re-install?

Its Simple you have to change in META-INF/context.xml change your connection details . 

 

    <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
        username="shreekrishna" password="passworddb"
        driverClassName="org.mariadb.jdbc.Driver"
        accessToUnderlyingConnectionAllowed = "true"
        validationQuery="SELECT 1"
        testOnBorrow="true"
        url="jdbc:mysql://localhost:3306/jasperserver8?useUnicode=true&amp;characterEncoding=UTF-8&amp;autoReconnectForPools=true&amp;tinyInt1isBit=false&amp;allowPublicKeyRetrieval=true"
        factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory"
         />

change your connection details. 

Edited April 28 by shreekrishna.shankhwar
wrong file name spelling mistake