Error: 18456 – Login failed for user

Login failed for user ‘viewcomposer’. (Microsoft SQL Server, Error: 18456)

Error 18456

The above error might show, if you use Microsoft SQL Server authentication instead of Windows authentication.

To get Microsoft SQL Server authentication working, we just have to enable it in the SQL Server Security settings:

Error 18456

One you enabled SQL Server and Windows Authentication mode, you need to restart the Microsoft SQL Server service.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.