January 18, 2008 at 10:08 am
I am a contractor not fluent in SQL but came into a situation were a company renamed a SQL server then migrated to another domain. I looked around and ran sp_removeserver and SP_addserver and also registed a SPN for the service account starting the services but still get numerous error listed below. I am wondering what the best fix for this is?
Event Type:Failure Audit
Event Source:MSSQLSERVER
Event Category:(4)
Event ID:18452
Date:1/18/2008
Time:9:54:21 AM
User:N/A
Computer:BDRDB001
Description:
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 10.0.240.60]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 14 48 00 00 0e 00 00 00 .H......
0008: 09 00 00 00 42 00 44 00 ....B.D.
0010: 52 00 44 00 42 00 30 00 R.D.B.0.
0018: 30 00 31 00 00 00 07 00 0.1.....
0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
0028: 74 00 65 00 72 00 00 00 t.e.r...
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(4)
Event ID:17806
Date:1/18/2008
Time:9:54:21 AM
User:N/A
Computer:BDRDB001
Description:
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 10.0.240.60]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 8e 45 00 00 14 00 00 00 E......
0008: 09 00 00 00 42 00 44 00 ....B.D.
0010: 52 00 44 00 42 00 30 00 R.D.B.0.
0018: 30 00 31 00 00 00 00 00 0.1.....
0020: 00 00 ..
January 18, 2008 at 10:30 am
I switched all SQL services to the local system account per a suggestion from Steve Jones and the previous errors have disapeared but not getting the below error
Event Type:Failure Audit
Event Source:MSSQLSERVER
Event Category:(4)
Event ID:18456
Date:1/18/2008
Time:10:28:03 AM
User:NT AUTHORITY\ANONYMOUS LOGON
Computer:BDRDB001
Description:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 10.0.240.60]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 09 00 00 00 42 00 44 00 ....B.D.
0010: 52 00 44 00 42 00 30 00 R.D.B.0.
0018: 30 00 31 00 00 00 07 00 0.1.....
0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
0028: 74 00 65 00 72 00 00 00 t.e.r...
January 18, 2008 at 11:10 am
That's a common error when you're trying to login with Integrated Security but it doesn't recognize the account name. If this server is now on a different domain, it may be that the Windows login account on the new domain has not been granted permissions to log in. Try logging in with a SQL Server authentication administrator account ("sa" if it's enabled), then check logins for the server to ensure that whatever the client accounts are that are trying to login are configured and enabled. You can view them in SSMS under Security once you have logged in.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply