I've added the followinbg to my script
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE [name] = 'Reality')
-- Create user for SQL Authentication
CREATE LOGIN Reality WITH PASSWORD = 'Games12er' ,DEFAULT_DATABASE = [Games]
-- Add User to first database
CREATE USER Reality FOR LOGIN Reality;
EXEC sp_addrolemember 'db_datareader', 'Reality'
EXEC sp_addrolemember 'db_datawriter', 'Reality'
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