Error: 18456, Severity: 14, State: 16


Error: 18456, Severity: 14, State: 16

Description State=16 means that the incoming user does not have permissions to log into the target database.  This can also happen if for example the default database for user is not online (for example the database is marked suspect or it is in restoring more).

Resolution

You can try all below different solutions to resolve the issue. As SQL Server 2005/2008 is not giving the reason for the login failure.

Thanks to SQL Server 2011 where it is stating the reason as well for the login failure.

Trouble shoot the suspect database issue or bring the database online or give the appropriate permission to user.

There may be case where default database is renamed, check that login is pointing correct database as default database.

Un-checked the auto-close connection from database properties.

If login is trying to open the database explicitly, check no job is running on that database which has opened it already explicitly.

Check if the login has appropriate permission on SQL Server and database.

Make sure Login credential is not expired.

There may be case where windows login re-created, drop the login from SQL Server and create it again.

 

Advertisements

2 thoughts on “Error: 18456, Severity: 14, State: 16

  1. Glenn

    Jugal, Is this a normal error on the server currently acting as the mirror? I believe it is since it is in a “Restoring” mode, but I’m looking for something official to document it for security purposes.
    Thanks!
    Glenn

    Reply

Thanks for the comment, will get back to you soon... Jugal Shah

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s