Couldn't login into the SQL Server using Windows authentication?

Question

Hi,

We are using SQL Server 2017. When we try to login in SQL Server with Windows authentication following error is prompting " Login failed for user 'domain\Administrator' (Microsoft SQL Server, error:18456" .Need support to resolve the issue And there is no SQL Authentication in created.

Answer 1

Hi @Francis Xavier ,

> Login failed for user 'domain\Administrator' (Microsoft SQL Server, error:18456"

For login error 18456, please check below;

1. Make sure you have create the login domain\Administrator in your SQL server login as below screenshot. If the login is not exist, please ask the administrator to add the domain\Administrator account to login list .

2. Make sure the login and the password are spelled correct.

If they are not work, suggest you reading the blog Troubleshooting Error 18456.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

Answer 2

Login failed for user 'domain\Administrator

You get the error, because the Windows account don't have permissions to logon to SQL Server. Note: Windows admin <> SQL admin, it has it's own permission system.
Grant logon and other required permissions for the Windows logon.