ID Number: Q75293
1.10 | 1.10
MS-DOS | OS/2
Summary:
SYMPTOMS
Attempting to login to SQL Server as system administrator (SA)
fails. It returns error message 911, "Attempt to locate entry in
Sysdatabases for database 'database_name' by name failed - no entry
found under that name. Make sure that name is entered properly."
CAUSE
The default database of SA was changed to "database_name" using
SP_DEFAULTDB, and that database has subsequently been dropped.
RESOLUTION
Both the MS-DOS and OS/2 versions of ISQL, files dated 10/03/90 or
later, will handle this error appropriately. They will allow the SA
to log in to SQL Server and place the SA in the master database.
Immediately change the default database of SA back to MASTER. This
can be accomplished with the following command:
SP_DEFAULTDB SA, MASTER