USE [master]

IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE [name] = 'Reality')
BEGIN
-- Create user for SQL Authentication  
CREATE LOGIN Reality WITH PASSWORD = 'Games12er' ,DEFAULT_DATABASE = [Games]  

-- Add User to first database  

USE Games;  

CREATE USER Reality FOR LOGIN Reality;  

EXEC sp_addrolemember 'db_datareader', 'Reality' 

EXEC sp_addrolemember 'db_datawriter', 'Reality' 

END