Summary
QE-DEF-0285 'The logon failed' error when generating a COGNOS Report Designer report.Symptoms
When attempting to run a Report Designer report you may encounter the following error in the GUI:QE-DEF-0285 'The logon failed'
Clicking the details button reveals the following:
QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: FNMReportDS
UDA-SQL-0031 Unable to access the "FNMReportDS" database.
UDA-SQL-0532 Data Source is not accessible: "<DatabaseName\Instance>".
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQLSTATE=08001, SQLERRORCODE=17)
You may notice that the database instance name is still pointing to an old instance.
The error may also still be present after changing the cognos configuration by running C:\Program Files (x86)\Report Designer\Configure_Flexnet_Report_Designer.exe (this is the default location, this may differ for your environment).
A re-install of Cognos Report Designer using the correct details still displays the same error.
Cause
This may have been caused by a misconfiguration of the database instance during the initial Cognos installation.Resolution
In the Report Designer interface navigate to Launch> IBM Cognos administration> configuration tab> data source connections > FNMReportDS> more > set properties> connection tab> connection stringPlease ensure that the connection string is referencing the correct database instance under Data Source =.
Example connection string:
^User ID:^?Password:;LOCAL;OL;DBInfo_Type=MS;Provider=SQLOLEDB;User ID=%s;Password=%s;Data Source=localhost,1433;Provider_String=Initial Catalog=flexnet_reporting_15.5;@COLSEQ=
Was this helpful?
0/255
Upload Attachment
File Upload
Maximum file
size allowed is 3 MB.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Are you sure you want to cancel the case creation?
Case closed successfully
File Upload
Maximum file size allowed is 3 MB.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
File Upload
Maximum file
size allowed is 3 MB.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Case id: 00001065
Activity: Status change: 2 hours ago