When we restore the database in SQL server, sometimes we may face problem in login with the existing login credentials in restored database. to fix the issue just run the below query by replacing the 'uname' with your login username.