This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Knowledge Base
- :
- How do I check / change the FNMSDatawarehouse connection?
Subscribe
- Mark as New
- Mark as Read
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
How do I check / change the FNMSDatawarehouse connection?
How do I check / change the FNMSDatawarehouse connection?
Summary
Here is the instructions for checking / changing the datawarehouse connectionSynopsis
For updating the DataWarehouse connection in the ComplianceConnection table, there is no interface to edit the connection details.Discussion
This can safely updated directly, since it uses integrated authentication. To update the connection details use the following queries (this is for single tenant on-premises installation):For updating both DB server and the DB name
update ComplianceConnection set Server = '<servername>', DatabaseName='<dbname>' where SourceType='FNMPDataWarehouse'
or For updating only the DB sever name
update ComplianceConnection set Server = '<servername>' where SourceType='FNMPDataWarehouse'
or For updating the DB name
update ComplianceConnection set DatabaseName='<dbname>' where SourceType='FNMPDataWarehouse'
Registry
The following registry key also needs to be modified
"HKLM\Software\Wow6432node\Managesoft Corp\Managesoft\Reporter\CurrentVersion" and update the connection string in the registry key "FNMPDWDatabaseConnectionString"
Update the references in Cognos. This can be edited through Cognos administration (i.e. as a web admin in Cognos Connection/Administration).
Additional Information
There is a bug - FNMS-25922 : Unable to Configure FNMPDataWarehouse DB connection details from UI
No ratings