Error 911

Troubleshooting SQL Server

Troubleshooting

Error 911

Severity Level 16
Message Text

Could not locate entry in sysdatabases for database '%.*ls'. No entry found with that name. Make sure that the name is entered correctly.

Explanation

This error occurs when attempting to change database context (with a USE statement) to a database that does not exist, or when the default database established for a login does not exist. In the latter case, the user login then attempts to access the master database.

Action

To obtain a list of databases, execute sp_helpdb or issuing this query:

SELECT name 
FROM master..sysdatabases

The list returned will contain the databases that exist on the Microsoft® SQL Server™ installation. Either create a missing database or connect to an existing one. To correct login-level errors, it may be necessary to execute sp_defaultdb.

See Also

Errors 1 - 999

sp_defaultdb

sp_helpdb

sysdatabases

USE