SQL Server / Login failed for user ‘DOMAIN\MACHINENAME$’. [SQLSTATE 28000]
Posted by Barac in SQL Server on Nov 14th, 2017 | 0 commentsMulti 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.
Message
[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:
- SQL Server / The target principal name is incorrect. Cannot generate SSPI context
- Azure / SQL Server / Cannot open user default database (Login failed)
- Azure SQL Managed Instances / SSMS / Connect to SQL Managed Instance / Public Endpoint
- Azure / SQL Server / Azure DB / Add Logins, Users, Permissions
- Azure SQL Managed Instances / SSMS / Connect to SQL Managed Instance / Private Endpoint
About Me
My name is Zoran, currently living in Auckland, New Zealand. I am a data specialist with more than 15 years of hands-on experience in database administration and optimisation. I am also, Certified Microsoft Trainer (MCT) and Microsoft Certified Solutions Expert (MCSE) with a Master‘s degree in Information Technology. Sharing knowledge and contributing to the SQL Server community is my passion. I am also an organiser of the Auckland SQL User Meetup Group. As well I am active blogger and speaker at different SQL events such as SQL Saturdays, Meetups etc.
read moreAuckland SQL Group
MSDN PROFILE
SQL SERVER UPDATES
- Microsoft SQL Server 2022 Updates / Release Candidate (RC 1) Evaluation Edition (16.0.950.9)
- Microsoft SQL Server 2019 Updates / BETA (15.0.1000.34) / RTM (15.0.2000.5)
- Microsoft SQL Server 2017 Updates / RTM (14.0.1000.169)
- Microsoft SQL Server 2016 Updates / RTM (13.0.1601.5) / SP1 (13.0.4001.0 or 13.1.4001.0) / SP2 (13.0.5026.0 or 13.2.5026.0) / SP3 (13.0.6300.2 or 13.3.6300.2)
- Microsoft SQL Server 2014 Updates / RTM (12.0.2000.0) / SP1 (12.0.4100.1 or 12.1.4100.1) / SP2 (12.0.5000.0 or 12.2.5000.0) / SP3 (12.0.6024.0 or 12.3.6024.0)
- Microsoft SQL Server 2012 Updates / RTM (11.00.2100) / SP1 (11.0.3000.0 or 11.1.3000.0) / SP2 (11.0.5058.0 or 11.2.5058.0) / SP3 (11.0.6020.0 or 11.3.6020.0) / SP4 (11.0.7001.0 or 11.4.7001.0)
Leave a Reply