cancel
Showing results for 
Search instead for 
Did you mean: 

Change Advanced Reporter password

Levon_Lyons
Community Manager

Change Advanced Reporter password

Changing the Setup User or Password

After deployment, it is possible to change the user associated with a deployment, or their password, if the need arises, for example, if you would like to use a service id. In order to do so, after deployment, go to the PASSWORDS Configuration and simply change the password entry for DB:<product> and Command:<product>. The screen shot below shows what these entries would look like for a deployment name of UC2.

After the PASSWORDS Configuration has been changed and “Started”, it will then be necessary to verify that the new User or Password is working. To do this, open the Windows Client and stop one of the running BigDataInsight database collections (the 12 hr dbc is recommended).

If the User/Password is correct, then the database will restart and continue running.

If the database collection fails to restart, then refer to the Error Log (WVLOG) file and check for ODBC errors. If only the Password was changed, and there are authentication errors in the wvlog file, then re-check that the password was entered correctly. If the User was changed and there are now authentication errors, then verify that the password was entered correctly, verify that the User has access to log into the SQL Server and then also verify that the User has an SQL login for the MSSQLSERVER application.

 

 

 

If my answer helped you today, please give my post a like and be sure to mark the 'Accept Solution' button to help others find the answer!
Cheers
Levon Lyons
1 REPLY 1
Levon_Lyons
Community Manager

Re: Change Advanced Reporter password

Here is the online help page 

 

 https://help.prognosis.com/server/119/sql-reporting-solutions/setup-procedures-for-sql-reporting-sol...

If my answer helped you today, please give my post a like and be sure to mark the 'Accept Solution' button to help others find the answer!
Cheers
Levon Lyons
Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar