Unable to login to SQL Server + SQL Server Authentication + Error: 18456
I have created login account on my localhost\sql2008 Server (Eg. User123)
Mapped to Database (default)
Authentication Mode on SQL Server is set to both (Windows and SQL)
But login to SQL Server fails with following message (for User123)
Note: Have checked multiple time that UserName / Password are typed in correctly
By default login failed error message is nothing but a client user connection has been refused by the server due to mismatch of login credentials. First task you might check is to see whether that user has relevant privileges on that SQL Server instance and relevant database too, thats good. Obviously if the necessary prvileges are not been set then you need to fix that issue by granting relevant privileges for that user login.
Althought if that user has relevant grants on database & server if the Server encounters any credential issues for that login then it will prevent in granting the authentication back to SQL Server
In summary:
- Right click on DBMS & select properties
- This window will open choose security & click on the both Windows & Sql Server Authentication.
- Restart your DBMS.
Now the same with pictures
Comentarios
Publicar un comentario
Dime si la información de este blog te sirvio.