Login failed [CLIENT: <local machine>]

[snootalope]

I can't not for the life of me figure out how to get rid of this message showing up in my new install of SQL 2005.

This is the message I'm seeing in the event log:

Event Type: Failure Audit
Event Source: MSSQL$IR_TEST
Event Category: (4)
Event ID: 18456
Date: 11/10/2006
Time: 9:00:52 AM
User: NBB\administrator
Computer: TESTSQL
Description:
Login failed for user 'NBB\Administrator'. [CLIENT: <local machine>]

Running a trace in the Profiler show's the failed login is for the ApplicationName: Report Server

The reporting service is starting with the same NNB\Administrator account. All accounts in the reporting service are the NNB\Administrator account.. The same account has full sysadmin rights.

I'm googled out here... anyone know how i can get rid of this?

 

[mrdenny]

Sounds like the Adminsitrator account's password was entered in incorrectly or the account doesn't have access to the IR_TEST instance of the machine.

You might want to look into setting up a seperate account for running all the SQL Services. Using the domain admin account isn't the best idea when it comes to security.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com