Login failed for user ‘viewcomposer’. (Microsoft SQL Server, 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:
One you enabled SQL Server and Windows Authentication mode, you need to restart the Microsoft SQL Server service.