Articles in this section
Category / Section

How to update credential details on the connection string for Report Server MySQL database ?

2 mins read

How to update credential details on the connection string for Report Server MySQL database ?

The credentials used to connect to the Report Server database in the Syncfusion Report Server can be changed at any time.

Report Server is deployed in the below location by default.

{Windows_Drive}\Syncfusion\Report Server\ReportServer.web\

For example, C:\Syncfusion\Report Server\ReportServer.web\

We have shipped a utility with the Syncfusion Report Server application in the below location.

{Windows_Drive}\Syncfusion\Report Server\Utilities\ConnectionStringEditor

 

Figure 1: ConnectionStringEditor utility installed location.

Follow the below steps to change the Database Credentials,

Step 1: Stop the Report Server from the Desktop shortcut – “Stop Syncfusion Report Server”

http://www.syncfusion.com/uploads/user/kb/ump/ump-2087/ump-2087_img2.png

Figure 2: Stop Syncfusion Report Server.

Step 2: Open the ConnectionStringEditor.exe tool in installed location.

C:\Users\Sasidharan.karuppiah\Desktop\KB\MySQL\ReportServer\ChangeDatabaseCredentials.png

Figure 3: Syncfusion Report Server -Connection String Editor form display.

Step 3: The connection details that were supplied while starting up the Report Server application will be populated in the utility.

The DSN, Username and the password can be changed for the MySQL database.

C:\Users\Sasidharan.karuppiah\Desktop\KB\MySQL\ReportServer\DSN.png

Figure 4: Select DSN Connection.

Note: This utility cannot be used when SQL CE database is chosen as the Report Server database in the Syncfusion Report Server.

 

Step 4: If the Username and Password for the database has already been given in the ODBC driver, it is not needed to be filled in this utility.

In this case, leave the Username and Password field as empty and then directly save the connection details.

If the login credentials are not given in the ODBC driver, this utility needs a Username and Password field to fill.

The utility will test the connection to the database with the given details. If the connection test passes, the new connection details will be updated in the connection string of the Report Server database.

 

C:\Users\Sasidharan.karuppiah\Desktop\KB\MySQL\ReportServer\without user.png

Figure 5: Save the connection details without login credentials.

 

C:\Users\Sasidharan.karuppiah\Desktop\KB\MySQL\ReportServer\Save.png

Figure 6: Save the connection details with login credentials.

 

The tool will change the Database Credentials and will return a “success” message if the process underwent successfully.

If there is an error occurred in the process, the tool will generate an error log in text format in the below location and display the error log file name.

Error log file location: %temp%/Syncfusion Report Server/{file_name}

Please create a support incident attaching this error log file for us to check the issue and give a solution.

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied