February 26, 2002 at 7:32 am
Apologies for the length of this.
PDC was NT4 and was replaced by a new machine running Win2K and ActiveDirectory.
Before this took place we had 3 member servers running Win2K and SQL2000. All allowed access thru Windows Authentication only without a hitch. Since the PDC has been replaced, 2 of them fail on Authentication. Both return 'Login failed for user 'NT AUTHORITY/ANONYMOUS LOGON'. The thing is it isn't anonymous! Even logged in as Administrator for the network I get this error on these two servers from a network client, but not from another server. Has anyone seen this problem before?
Tech details -Win2K SP2, SQL2000 SP 2.
TIA,
Paul
February 28, 2002 at 5:04 am
Try this..
login locally to the server (dont login to the domain)... if you havent played with the builtin administrators account should should be able to connect via EE without any problems (if there is a prod, register the server). Once dont goto security tab and set the server to mixed mode and set passwords accordingly for the time being. Fix logins as required.
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
March 3, 2002 at 6:46 am
It might be that you didn't map the old NT sid's on the new PDC.
For trusted security SQL Server stores NT security sid's in its local Windows Registry and then maps this in the master..sysxlogins table.
If your Domain is now WIN2k, how did you update the sid's in the local registry?
You can check out the article Q240872 on the Microsoft KB.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply