4064

Product Name

Event ID

4064

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

DB_UFAIL_FATAL

Message Text

Cannot open user default database. Login failed.

The SQL Server login was unable to connect to SQL Server, either due to permission issues with

a database user associated with the login in the default database, or a problem with its default

database.

Permission issues can be one or more of the following:

The login doesn’t have a corresponding mapped user in its default database.

You assigned a default database to the login but didn’t create a user mapping in the

specified database.

The mapped user for the login has been denied access. (For example, this can happen if

the user is inadvertently added to a

fixed database role.)

The default database might be unavailable at the time of connection for the following reasons:

The default database is in suspect mode.

The default database no longer exists.

The default database name isn’t correct.

The default database is in single-user mode, and the only available connection is already

used by someone or something else.

The default database has been detached.

ﾉ

Expand table