Hi Saqib, Did you create the login on the server? And you added the login as a user to the database ?
Can you please verify if your login is added to the database? please try running these queries under your database
Thanks
select pri.name,pri.type_desc,dpri.name as RoleMembers
from sys.database_role_members rm
right join sys.database_principals pri
on pri.principal_id=rm.role_principal_id
left join sys.database_principals dpri
on dpri.principal_id=rm.member_principal_id
Where pri.name like '%YourLOGIN%'
go
SELECT spl.name,spl.type_desc,spl.is_disabled
from sys.server_principals spl
inner join sys.database_principals dpl
on spl.name=dpl.name
where dpl.name like '%inte%'
