RE: SQL 2008 Error 18456 Severity 14 State 11

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi David,

Instead of using the NT Authority\Anonymous logon I would recommend you
create a new Domain account with limited permissions on domain and grant it
access to SQL Server and the database.

For new database login, you should not need to give it any permissions.
And for database user you will need to give db_ddladmin, db_datawriter, and
db_datareader.

Login State 11 means that the user does not have access to the database.
I think because you are putting on another computer now the NT Authority
account on that computer is invalid on SQL Server. If you were to use a
domain account that is same across all computers with same SID you shouldn't
have this issue...

Thanks.

ref:
http://sqllearnings.blogspot.com/2008/10/error-18456-severity-14-login-failed.html
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"DavidS" wrote:

We are running SQL 2008 with a single database that is receiving data from a
logging application. When forwarding the information from the application
residing on the same server, everything works fine. When trying to forward
the data from another server on the same LAN, the data does not forward and
the SQL logs show the error 18456, Severity 14, State 11 for user NT
Authority\Anonymous Logon. The odd thing is, the logging application has a
function that will create a table on the SQL server and send a test message.
These functions work with no errors and the test message will show up in the
table, but it will not forward the logging data when we activate the
connection.

Any help would be greatly appreciated. TiA.

.

Relevant Pages

  • Re: .NET and SQL Server on Separate Machines
    ... add this domain account as a valid login to your sql server. ... Everything was running correctly when the database ... > The connection string in our web.config file originally looked like this: ...
    (microsoft.public.sqlserver.connect)
  • Re: .NET and SQL Server on Separate Machines
    ... add this domain account as a valid login to your sql server. ... Everything was running correctly when the database ... > The connection string in our web.config file originally looked like this: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Server does not exist or access denied.
    ... IIS to use that domain account as its process identity. ... > access to the database it and it worked just so fine. ... i am installing my asp.net app and database to a new production ... > now i get an error "SQL Server does not exist or access denied". ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: SQL Services account question...
    ... I wish you'd say the reason of not using a domain account as a service account for the SQL Server. ... Backup operations are performed by SQL Server service, at this point I don't know what goes on under hood exactly but SQL Server service may be needed to communicate to the AD for validation of the database owner and as the SQL Server service is a local one, it can't achieve this task. ... > Source: Security Event ID: 537 ...
    (microsoft.public.sqlserver.security)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)