Wednesday, August 22, 2007

MS: SQL Server Login Failed for SMS 2003 Secondary Site server account

Error Message:

Event Type: Failure
AuditEvent Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 22/08/2007
Time: 13:18:24
User: SMSDEMO\GMPIL-SMS2$
Computer: GMPIL-SMS1
Description:Login failed for user 'SMSDEMO\GMPIL-SMS2$'. [CLIENT: 192.168.179.102]

MSSQLSERVER 18456 Login failed for user SMS 2003

Solution:

Add the computer account of the Secondary Site server to the SMS_SiteSystemToSQLConnection_ local group on the Primary Site server.
This allows the Secondary Site server to access the Primary Site server's SQL database.

No comments: