11
Cannot open default database ’%.*s’.
Error 4001 is raised when Adaptive Server is unable to open the users default database at login.
After raising the error, the server verifies whether the user is allowed to log in to master. If the master database is forbidden for the user, the login request is denied.
Common reasons why the default database cannot be opened include:
The database may not be available for use. For example, it may be in recovery.
The database may be up, but not available for general use. For example, it may be undergoing failover as part of the High Availability (HA) subsystem.
Permission checks failed. For example, if the database was created by loading from another server, but the login information in the source and target servers does not match, login may fail.
Retry the login in the event that the database was in recovery or temporarily unavailable.
Since the 4001 error is usually a symptom of another problem, check the server error log for any other errors that may have been raised prior to 4001. Check for the following errors and retry:
921 errors (Database ’%.*s’ has
not been recovered yet - please wait and try again.)
indicate that the database is in recovery, or is marked suspect
due to an earlier problem. Refer to the “Error 921” for instructions.
2206 errors (Database %.*s
with dbid %d is already shut down.)
indicate that the database is not available for general use. These errors
are raised in version 12.0 and later. Check for other HA subsystem messages
to determine the cause.
10351 errors (Server user id %d
is not a valid user in database ’%.*s’)
indicate a permissions problem. If the database was loaded from
another server, the problem may be due to an incorrect suid/uid combination
in sysusers. Check syslogins entries
in the source and target server, respectively. Refer to “Step
12: Restore server user IDs” in the chapter “Restoring
System Databases” the System Administration Guide:
Volume 2 for details.
All versions
