I am dealing with the infamous "Login failed for user 'domain\machinename$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]"
After searching the internet I have tried adding "NT AUTHORITY\NETWORK SERVICE" with db_DataReader in Master and MSDB, then promoting it to SysAdmin when the former didn't stop the error messages.
I tried the above first, after reading that trying Domain\MachineName$ was a red herring.
After none of that worked, I tried adding the Domain\MachineName$ with the same rights, then SysAdmin on the server.
None of the above has worked. I don't know what to try next.
I need to know what I to do here, and if it is adding a user to SQL Server, I need to know what rights it needs to be granted, in one or more DBs, and/or what server roles is must be granted. Also, is a service restart necessary for the solution to take affect?
This is on SQL Server 2014, on an Azure VM running Win 2012.