SQL Server / Login failed for user ‘DOMAIN\MACHINENAME$’. [SQLSTATE 28000]

Multi Server Administration MSX/TSX.

When I have multiple instances with same or similar jobs I usualy use Multi Server Administration to create the job just once and then add target servers for that job.

I just wanted to point out some errors you can face during Multi Server Administration implementation.

[298] SQLServer Error: 18456, Login failed for user ‘DOMAIN\MACHINENAME$’. [SQLSTATE 28000]

What does this mean.

Your SQL Server Agent probably using NETWORK SERVICE credential for log on account (default NT Service\SQLSERVERAGENT).
NETWORK SERVICE will authenticate himself always as the corresponding account locally. Nevertheless, process running as NETWORK SERVICE trying to access a remote instance will be authenticated as the remote machine account.

Example, ‘DOMAIN\MACHINENAME$’, login will fail since you need to grant access to this account.

You can solve this in two ways, you can create login and grant permissions to the machine account ‘DOMAIN\MACHINENAME$’ instead NETWORK SERVICE.

Or you can create new user for SQLSERVERAGENT service account rather than granting an access to the machine account. (Recommended)



Similar Posts:

Leave a Reply

Your email address will not be published. Required fields are marked *