Hi again,

I've added the followinbg to my script

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

I figured it is easier to use sql authentication. Please advise me if this is correct. it seems to have worked on my pc. still have to test on a users pc