IBM Support

'Cannot open user default database. Login failed.' during ODBC DSN Setup - Sterling Gentran:Server for Microsoft Windows

Troubleshooting


Problem

'Cannot open user default database. Login failed.' during ODBC DSN Setup

Symptom

Error 4064, Cannot open user default database. Login failed.

Cause

The User's default database has been deleted or renamed, or the user has not been granted at least the public role on the database.

Resolving The Problem

Contact the SQL Server DBA to check that the database exists, and that the user has at least the public role in the database.

If the problem persists, it might be necessary to contact Microsoft Support for assistance.

[{"Product":{"code":"SS6V3G","label":"Sterling Gentran:Server for Microsoft Windows"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"}],"Version":"5.3.1;5.3;5.2","Edition":"","Line of Business":{"code":"","label":""}}]

Historical Number

PRI4104;SCI20811

Document Information

Modified date:
16 June 2018

UID

swg21547216