SQL Error 18456 when connecting to the server

Question

SQL Error 18456 when connecting to the server

Navigation

#1 by (3 votes)

1

I'm having trouble connecting to "SQL Sever Authentication."

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

Can not connect to CRONOPIO. Login failed for user 'Cronopio \ Lucas'. (Microsoft SQL Sever Error: 18456.

I also tried logging in simply by using "Lucas" but still I get the error. There are no problems when logging in with Windows authentication but I need to do a job and it is necessary to log in with SQL.

Update:

sql sql-server

asked by Lucas. D 30.10.2016 в 03:34

source

1 answer

How can I auto-increment an alphanumeric field with idendity Use driver without $ scope

score 3 · Accepted Answer

To connect in SQL Sever Authentication mode, 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 Windows Authentication . You can verify this by looking at the properties of that login ( Security --> Logins ). You can not use this login to login in SQL Sever Authentication mode.

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