question

FrancisXavier-9103 avatar image
0 Votes"
FrancisXavier-9103 asked FrancisXavier-9103 commented

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

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.

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @FrancisXavier-9103,

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 .

115304-screenshot-2021-07-16-150553.jpg

115305-screenshot-2021-07-16-150719.jpg

  1. 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.




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered FrancisXavier-9103 commented

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.



· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

How can I provide the right to that account

0 Votes 0 ·

But you have a login with SQL SysAdmin permissions to create a login? Then see Create a Login


0 Votes 0 ·

Actually that SQL SysAdmin account has not been created. That is the main drawback for me because in this application.

0 Votes 0 ·
Show more comments