I am trying to connect to our SQL server 2012 database engine using SSMS but it fails with error 18456. I am logged in as the built-in administrator account on the windows server where the DB is installed and the database engine is configured to use Windows authentication. Details of the error in SQL server logs are as follows:

2016-08-30 11:04:01.290 Logon        Error: 18456, Severity: 14, State: 5.


2016-08-30 11:04:01.290 Logon        Login failed for user 'SERVERNAME\Administrator'. Reason: Could not find a login matching the name provided. [CLIENT: ]


I will appreciate any assistance resolving this problem.

1 Answer 1


Even though you are logged in as an administrator to the server were sql is running and installed, that login must still be a valid login in Sql Server with appropriate permission, is this the case?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.