Error: 18456, Severity: 14, State: 16

Question

Post reply

Error: 18456, Severity: 14, State: 16

gianni.fusto

SSC Veteran

Points: 222
More actions
May 22, 2008 at 8:50 am

#186973

Hi,
I have a problem with sql 2005 enterprise.
After I changed Server Collation of SQL Server 2005 (with rebuild master database) every minute comes visualized
the following message:
Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: ]
Error: 18456, Severity: 14, State: 16.
I do not succeed to understand where it can be the problem 🙁 🙁 🙁

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

mobasha SSCertifiable Points: 5334 More actions · Answer 1

have u checked the service account u might need to retype the password or change the service account user.

..>>..

MobashA

gianni.fusto SSC Veteran Points: 222 More actions · Answer 2

Hi,

all services start with logon as local system................

I do not resolve I must change the password NT AUTHORITY\SYSTEM ????????

Thanks

gianni.fusto SSC Veteran Points: 222 More actions · Answer 3

Hi,

I have made ulterior tests, holding blocked the following services:

- Sql server Agent

- Full text search

but the error messages continue.........:crying: :crying: :crying:

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 4

NT Authority\System is the username for any account that runs as LocalSystem

Generally the sQL services should not be running as local system. They should ahve their own domain accounts.

If you do want them running as LocalSystem, then BuiltIn\Administrators needs to be a login in hyour SQL server.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

gianni.fusto SSC Veteran Points: 222 More actions · Answer 5

HI,

I have tried to change account for every service.

The problem is with the following service "SQL Server Reporting Services (MSSQLSERVER)"

If I change account for this service, the message change in Login failed for user 'DOMewprofile'. [CLIENT: ]

:crying:

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 6

Did you enter the correct password? Does that login have rights in the server?

What's the State listed for the error? (Error 18456, Severity 14, State ??)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

gianni.fusto SSC Veteran Points: 222 More actions · Answer 7

gianni.fusto (5/26/2008)
HI,
I have tried to change account for every service.
The problem is with the following service "SQL Server Reporting Services (MSSQLSERVER)"
If I change account for this service, the message change in Login failed for user 'DOMewprofile'. [CLIENT: ]
:crying:

Resolved problem,

I have recreated database the ReportServer and the message does not appear more.

Thanks for all

gianni.fusto SSC Veteran Points: 222 More actions · Answer 8

GilaMonster (5/26/2008)
Did you enter the correct password? Does that login have rights in the server?
What's the State listed for the error? (Error 18456, Severity 14, State ??)

Sorry,

the message was

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

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 9

State 16 means that the login does not have rights on default db. That would explain why recreating the report service database fixed the issue.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass