Home / Questions / 30647
Accepted
Lucas. D
Asked: 2020-10-30 18:34:40 +0800 CST 2020-10-30 18:34:40 +0800 CST

SQL Error 18456 when connecting to server

  • 772

I am having trouble connecting with "SQL Sever Authentication".

When I installed the program in the Database Engine Configuration part I selected mixed authentication mode, this created an administrator "CRONOPIO\Lucas(Lucas)" but when trying to log in from SQL I get the error:

Cannot connect to CRONOPIO. Login failed for user 'Cronopio\Lucas' . (Microsoft SQL Server Error: 18456.

I've also tried logging in using just "Lucas" but I still get the error. There are no problems logging in with Windows authentication but I need to do some work and it is necessary to log in with SQL.

Update:

enter image description here

sql

1 Answers

  1. Best Answer

    To connect in mode SQL Sever Authentication, you must use a login that was created for that mode.

    The administrator ( CRONOPIO\Lucas(Lucas)) that was created when installing the database must be of type Windows Authentication . You can verify this by looking at the properties of that login ( Security --> Logins). You cannot use this login to login in mode SQL Sever Authentication.

    What you need is to create a new login created specifically for SQL Sever Authentication. For this, go to Security --> Logins, and do New Login.... There, make sure to choose SQL Sever Authentication:

    enter image description here

    • 3