Cognos error: QE-DEF-0322 The connection string is invalid. RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: FNMP-DW-DS

[#1]

Summary

QE-DEF-0322 The connection string is invalid.RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: FNMP-DW-DS

Symptoms

Upgrade Cognos to 2016 R1, on opening any reports/dashboard receive the following login failure message:

QE-DEF-0322 The connection string is invalid.RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: FNMP-DW-DS
UDA-SQL-0031 Unable to access the "FNMP-DW-DS" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.UDA-SQL-0534 Invalid connection string.

Cause

When FlexNet Report Designer is installed on a server other than the database server running the content store database, Microsoft SQL Server Native Client must be installed on the server hosting FlexNet Report Designer.

Resolution

Install SQL native client on the cognos server. Installation instructions are available online, and you can start from
https://msdn.microsoft.com/en-au/data/aa937733

Additional Information

Refer to the 'Installing FlexNet Manager Suite 2016 R1' guide under topic - Install FlexNet Report Designer for more information.

[darwin_hammons]

Running 2017 R3.. with ContentStore and FNMP Dashboard on same server.  Still have error

[sunshine]

Could you please check the connection details are correct for the mentioned datasource: FNMP-DW-DS on Cognos. To check this, on the Cognos UI if you are logged in as Analytics Administrator:

-Click on the Manage icon 'click mark icon' around the bottom left side of the navigation bar.

-Then navigate to Administration Console>Configuration>Data Source Connections.

-Notice the FNMP-DW-DS group listed

-Click on the above group and then click on the ‘More’ link under Actions on the right side of the page.

-Then navigate to Set Properties>Connection.

-Next to the ‘Connection String’ field, click on the pencil icon ‘Edit the connection string’.

-Check both the ‘Native’ and ‘JDBC’ tabs to make sure connection details there are correct. Also you could perform Test connection there to see which one is failing.

Thanks.