ID Number: Q80980
1.11
OS/2
buglist1.11
Summary:
Problem ID: PRSQL9202009
SYMPTOMS
If a default database other than MASTER has been established for a
SQL Server login ID and that database fails to recover for any
reason, the user will be unable to log into SQL Server.
CAUSE
SQL Server incorrectly handles the login procedure when a user's
default database is inaccessible. If SQL Server cannot log that
user ID into its default database, it should log it into the MASTER
database.
WORKAROUND
There are several ways to work around this problem. If the system
administrator's (SA's) default database is accessible, the SA can
log in and change that user's default database to something other
than the one that is inaccessible.
However, if the SA's default database is inaccessible, a previous
version of the PDBLIB.DLL or ISQL.EXE file may be necessary.
Specifically, using the PDBLIB.DLL dated 10/3/90 will allow the SA
to log in to the MASTER database using SAF and/or ISQL on the
server or from an OS/2 client. Additionally, the MS-DOS versions of
ISQL.EXE and SAF.EXE dated 10/3/90 will also allow the SA to log on
from an MS-DOS client.
STATUS
Microsoft has confirmed this to be a problem in SQL Server version
1.11. This problem does not occur in SQL Server version 4.2.