Question

How to change the username and password used in Reporting Service?

Answer

If the new user has already been created in the database server, this user's credentials should be applied in AppSettings in both Reporting Services and Reporting Data Access, Reporting Service Windows Service, and IIS Application Pool.

Updating AppSettings 

1. Open the command prompt and execute the following command in the C:\inetpub\wwwroot\FlexiCapture12Reporting\CreateDb folder:
   .\EventLogApiCreateDb.exe <Server Instance> <DB name> <username> <password> connect
2. The above command will create a new connection string similar to the image below:
3. Copy the connection string to appsettings.json for the Reporting Service (the default path is C:\inetpub\wwwroot\FlexiCapture12Reporting). Example:
   Data Source=DELACRUZ-NB\FLEXICAPTUREDB;Initial Catalog=testDB2346;User ID=test;Password=/DopobX1XaAyoORWuvR0NQ==;TrustServerCertificate=yes"  
4. Copy the connection string to the appsettings.json located in C:\inetpub\wwwroot\FlexiCapture12ReportingDataAccess as well.

Updating Windows Service

1. Press the Windows + R keys and type services.msc then press Enter.
2. Look for the FlexiCapture Reporting Service.
3. Double-click or Right click and select properties.
4. Go to the Log On tab, select This account option then browse or type in the username and password.
   

Updating Application Pool

1. Press the Windows + R keys and type inetmgr then press Enter.
2. Go to Application Pools.
3. On the right side look for FlexiCapture 12 Reporting.
4. Highlight it, then on the right side of it click on Advanced Settings or Right click on it and select Advanced Settings.
   
5. Look for Identity and click on it.
   
6. Click on the 3 dots on the right side, choose Custom Account, and click Set.
   • 
7. Define the username and password.

Note: All usernames and passwords should match.

In case there is no database user yet created, check the related database documentation:

• SQL Server
• Oracle Server