sql server connect: Error: 18456, Severity: 14, State: 16. -- sql server connect

Error: 18456, Severity: 14, State: 16.

payyans
10/10/2007 11:08:01 AM

sql server connect: Our java web application is running into a login failure issue as shown below
after a few hours of its run.
Login failed for user '<user name>'. [CLIENT: <IP Address>]
Please note that application makes several connections to database for its
processing purpose.

We are using SQL Server 2005 Standard Edition (Build#3152) on dual processor
machine. I came across a Microsoft article,
http://msdn2.microsoft.com/en-us/library/ms366351.aspx. But it does not
mention anything about the State 16.

If you have come across such a situation or having a solution for the error,
it is appreciated.
Thanks,
payyans

Re: Error: 18456, Severity: 14, State: 16.

payyans
10/10/2007 1:23:00 PM

The application was able to make connections using the same credentials in
the initial hours of run. So, I am not sure why permission is denied at a
later point. Thanks for the response.
-payyans

[quoted text, click to view]

Re: Error: 18456, Severity: 14, State: 16.

Russell Fields
10/10/2007 2:35:05 PM

payyans,

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx include
some blog discussion that defines State 16 as:
The user does not have permission to log into the target database. (Perhaps
the login's default database is one to which it has no rights or the
database is offline.)

Hope that helps you find your problem,
RLF

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.