Error: 18456, Severity: 14, State: 5.
Question
Thursday, July 25, 2013 11:00 AM
Hi
We are on SQL SErver 2012 which was recently migrated on.
I am seeing lots of errors like "
Error: 18456, Severity: 14, State: 5.
Login failed for user 'Domain\Server$'. Reason: Could not find a login matching the name provided. [CLIENT: XX.XX.XX.XX]
Please suggest
All replies (5)
Friday, July 26, 2013 6:33 AM âś…Answered
Hi Orbitdba,
Could you confirm us where you got these errors? SQL Server Logs or consoles?And how you logged on your SQL Server? Appreciate your elaboration for your scenario.
NETWORK SERVICE and LocalSystem will authenticate themselves always as the corresponding account locally (built in\network service and built in\system) but both will authenticate as the machine account remotely.If you see a failure like Login failed for user 'DOMAIN\MACHINENAME$' it means that a process running as NETWORK SERVICE or as Local System has accessed a remote resource, has authenticated itself as the machine account and was denied authorization.
We could fix this issue by following method:
Add the machine account to your SQL Server. You can first locally log on your SQL Server instance with a local administrator via SSMS, expand Security folder->right click Login->click New Login..., check Windows Authentication and type the machine account "Domain\ServerName$" as the login name, and then you may assign the account permissions by selecting the server roles and specify the related databases by selecting the User Mapping.
For further more information, please refer below links.
Login failed for user 'DOMAIN\MACHINENAME$'
http://stackoverflow.com/questions/2806438/login-failed-for-user-domain-machinename
Login Failed for Domain\ServerName$ when trying to create a new SQL Server Reporting Services Application in SharePoint 2013
login failed for user domain\servername$
http://forums.iis.net/t/1196344.aspx/1
Thanks,
Candy Zhou
Thursday, July 25, 2013 11:02 AM
Hallo Orbitdba,
as the error message decribes...
A machine account tries to access your server.
Check the server itself and proof the application which forces the connection
If it's o.k. add the machine account as login and appropriate permissions to the databases it want to access.
MCM - SQL Server 2008
MCSE - SQL Server 2012
db Berater GmbH
SQL Server Blog (german only)
Thursday, July 25, 2013 11:16 AM
Hi,
I don't know where this connection "user 'Domain\Server$'. " is coming from
How can I check it?
Thursday, July 25, 2013 11:26 AM
It's coming from CLIENT: xxx.xxx.xxx.xxx!
You have to localize the machine and check the running applications / application pools (if web server) and so on...
This is the root object you have to localize first!
MCM - SQL Server 2008
MCSE - SQL Server 2012
db Berater GmbH
SQL Server Blog (german only)
Friday, July 26, 2013 6:39 AM
invalid user name to can you make sure that the user is added in the SQL Server Logins
Log on to the SQL Server _>security-> logins-> add the user name with the login name.
Ramesh Babu Vavilla MCTS,MSBI