MSSQLSERVER_4064
Details
Product Name |
SQL Server |
Product Version |
10.0 |
Product Build Number |
10 |
Event ID |
4064 |
Event Source |
MSSQLSERVER |
Component |
SQLEngine |
Symbolic Name |
DB_UFAIL_FATAL |
Message Text |
Cannot open user default database. Login failed. |
Explanation
The SQL Server login was unable to connect because of a problem with its default database. Either the database itself is invalid or the login lacks CONNECT permission on the database.
User Action
Use ALTER LOGIN to change the login's default database. Grant CONNECT permission to the login.