Error: 18456, Severity: 14, State: 16
Wednesday, March 28, 2007 at 06:08PM Microsoft SQL Server 2005 has been reporting an error for about three weeks. I would have never noticed it but this afternoon Reporting Services failed and brought our production system to a halt. Of course now I realize that this was not the source of the problem but if you are like me, any reported failures in the event log should be resolved, at least, explained.
The Application Event Log reported this error:
Source: MSSQLSERVER
Category: (4)
Event ID: 18456
Type: Failure Audit
User: domain\userDescription: Login failed for user 'domain\user'. [CLIENT: <local machine>]
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 07 00 00 00 42 00 4c 00 ....B.L.
0010: 41 00 44 00 45 00 32 00 A.D.E.2.
0018: 00 00 07 00 00 00 6d 00 ......m.
0020: 61 00 73 00 74 00 65 00 a.s.t.e.
0028: 72 00 00 00 r...
The data portion of the event properties reveals that the user account was attempting to use the master database. Using the Log File Viewer for SQL Server, I noticed the following entry:
Date 3/28/2007 5:28:00 PM
Log SQL Server (Current - 3/28/2007 6:01:00 PM)Source Logon
Message
Error: 18456, Severity: 14, State: 16.
I was stumped because 'domain\user', which is a domain service account has the sysadmin role for SQL Server. I searched on Google and could not find a solution. By accident, I clicked on the SQL Agent Log and found two entries:
[298] SQLServer Error: 18456, Login failed for user 'domain\user'. [SQLSTATE 28000]
[298] SQLServer Error: 4060, Cannot open database "ASPState" requested by the login. The login failed. [SQLSTATE 42000]
Then it occurred to me that when I recently moved my ASP.net out-of-process state server from this server to a high-availability cluster server, I took the database offline to make sure that all references to it had been changed. Apparently SQL Agent is responsible for ASPState cleanup and the entries to perform the clean up reside in the master database. The Agent could not gain access to the database because it was offline so it reported the error.
For those of you that have installed an ASP.net application or state server in SQL Server, you will have to use the aspnet_regsql tool to remove it. Manually deleting the databases or taking them offline will produce these errors.
Reader Comments (4)
Gnat.
.
There are some people who say that top branded drugs are way more effective than the generic ones. However, this does not hold much truth when it comes to the generic medicines which are sold here. An online pharmacy which offers generic medicines at affordable prices. If you have been diagnosed with a sickness and your medication requires you to spend a lot for your medicines, you don't have to worry about this anymore. You can by <a href="http://www.onlinepharmacy.vg/catalog/-c-32_469.html">Cialis</a> and get a discount when you keep on buying the same drug. When you cannot tolerate the high price of branded medicines, your only option is an online pharmacy, since it is compassionate with your need for reasonably priced drugs.
If your medication calls for high-priced branded medicines, why not <a href="http://www.onlinepharmacy.vg/catalog/-c-32_469.html">Generic Cialis</a>? This is an alternative which is provided at your affordable online drug store. One of the advantages that you can get from this store is the fact that its medicines can be bought for very low prices. You can order generic drugs at the website. These medicines are formulated with ingredients which are equal to the ones which make up branded drugs. However, the prices of the two are entirely different. Even though the prices of generic drugs and branded drugs vary widely, the effects are still the same. This is due to the fact that the medicines which are sold at this online pharmacy have been approved by worldwide organizations. The effectiveness and the quality of the generic drugs are regarded as excellent. The legality of these drugs has been supported by international regulatory boards. Some of these authorities are South Africa MCC, USA FDA, and WHO.
When you <a href="http://www.onlinepharmacy.vg/catalog/-c-32_469.html">Buy Cialis</a>, the shipping service is offered for free. If you are residing within the European continent or at the other pole of the globe, the medicines that you have ordered will still be delivered to you. If you are a resident from the USA or from Europe, the duration of the shipping service can take fourteen days. One of the services that this online drug store provides its customers with is the chance to get a discount. Each time you order the same drug, you will be offered with a five-percent discount. Since the online pharmacy is compassionate with the plight of its sick patients, it does not charge you with hidden fees. Nor does it charge you when you consult with its physicians.
You can <a href="http://www.onlinepharmacy.vg/catalog/-c-32_469.html">Buy Cialis</a> when you are diagnosed with a sickness. Serious ailments such as cancer or manic depression can be treated with some of the medicines sold at this online pharmacy.
Author
Mark Garet http://www.onlinepharmacy.vg/catalog/-c-32_469.html
There are some people who say that top branded drugs are way more effective than the generic ones. However, this does not hold much truth when it comes to the generic medicines which are sold here. An online pharmacy which offers generic medicines at affordable prices. If you have been diagnosed with a sickness and your medication requires you to spend a lot for your medicines, you don't have to worry about this anymore. You can buy cialis and get a discount when you keep on buying the same drug. When you cannot tolerate the high price of branded medicines, your only option is an online pharmacy, since it is compassionate with your need for reasonably priced drugs.
If your medication calls for high-priced branded medicines, why not generic cialis? This is an alternative which is provided at your affordable online drug store. One of the advantages that you can get from this store is the fact that its medicines can be bought for very low prices. You can order generic drugs at the website. These medicines are formulated with ingredients which are equal to the ones which make up branded drugs. However, the prices of the two are entirely different. Even though the prices of generic drugs and branded drugs vary widely, the effects are still the same. This is due to the fact that the medicines which are sold at this online pharmacy have been approved by worldwide organizations. The effectiveness and the quality of the generic drugs are regarded as excellent. The legality of these drugs has been supported by international regulatory boards. Some of these authorities are South Africa MCC, USA FDA, and WHO.
When you buy cialis, the shipping service is offered for free. If you are residing within the European continent or at the other pole of the globe, the medicines that you have ordered will still be delivered to you. If you are a resident from the USA or from Europe, the duration of the shipping service can take fourteen days. One of the services that this online drug store provides its customers with is the chance to get a discount. Each time you order the same drug, you will be offered with a five-percent discount. Since the online pharmacy is compassionate with the plight of its sick patients, it does not charge you with hidden fees. Nor does it charge you when you consult with its physicians.
You can buy cialis when you are diagnosed with a sickness. Serious ailments such as cancer or manic depression can be treated with some of the medicines sold at this online pharmacy.
Author
Mark Garet http://www.onlinepharmacy.vg/catalog/-c-32_469.html