Microsoft SQL server error 18456 how to solve?

Question

SQL Server

SQL server and the database was deployed under user (X) . When trying to connect to the server via Windows Authentication from user (Y), it gives an error
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536.
Is it possible to get access from user (Y) or will it be easier to demolish and re-deploy?

Answer 1

MSSQLSERVER_18456 .