--step1: Enabling containment type at instance level

sp_configure 'contained database authentication',1
reconfigure
--step2: DB Level
USE [master]
GO
ALTER DATABASE [TLogDemo] SET CONTAINMENT = PARTIAL WITH NO_WAIT
GO
--step3: Create user with password
use TLogDemo
go
create user Pankaj with password='Hyd@1234'
go
grant select to Pankaj
--step4: Connect with Pankaj