IBM Support

Trusted Signon using SQLOLEDB

Troubleshooting


Problem

Attempting to connect to a MSSQL Database using SQLOLEDB produces the following error: [Error number -258:] DMS-E-GENERAL, A general exception has occurred during operation 'attach direct'. DMS-E-RDS_OLEDB, The OLE DB provider has returned the following error: HRESULT: DB_SEC_E_AUTH_FAILED Microsoft OLE DB Provider for SQL Server Login failed for user ''. SQLSTATE = 42000, ERROR = 18456

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF025","label":"Platform Independent"}],"Version":"Impromptu 7.0;Impromptu 7.1;Impromptu 7.3;Impromptu Web Reports 6.0;Impromptu Web Reports 7.1;Impromptu Web Reports 7.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu Web Reports","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

112762

Document Information

Modified date:
09 May 2025

UID

swg21349198