SQL 2005 no longer authenticating a Windows Computer Account instead NT AUTHORITY\ANONYMOUS LOGON
- From: Rob45 <rob.hall45@xxxxxxxxx>
- Date: 15 May 2007 01:52:24 -0700
Hi, I have a SQL 2005 server which was in Windows Authentication mode
for SMS 2003, I have changed this to Mixed mode as I have had to put
on some additional DB`s. I also made a mistake and had to restore the
MASTER database (oops!).
Ever since I have restored the MASTER Database I have broken the
security to my SMS 2003 database.
Before the computer account of remote machines were used to connect to
the database, but now the NT AUTHORITY\ANONYMOUS LOGON account is
being used. This was failing with the following error
Error: 18456, Severity: 14, State: 11.
After much play I recreated the 'NT AUTHORITY\ANONYMOUS LOGON' and the
error changed to:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT:
Error: 18456, Severity: 14, State: 16.
If I grant this sysadmin it successfully connects but obviously I do
not want to allow this massive security risk.
The remote computers should be using their Computer Accounts to
connect with Windows Authentication, there is a group in the Master
Database containing these computers which has the correct access to
the SMS database, however it appears as if this is not being used.
Anyone any ideas?
- Prev by Date: Re: SQL server 2000 security question with app developer premissio
- Next by Date: Re: Tracking when someone enters Enterprise Manager
- Previous by thread: Re: Help! Set up Windows Group to access application
- Next by thread: Re: SQL 2005 no longer authenticating a Windows Computer Account inste