Please use this SQL Statement in Microsoft SQL Management Studio:

(You can also use the attached query file)


USE [Colorware]

GO


if NOT EXISTS (SELECT * FROM sys.syslogins WHERE name = 'colorware')

BEGIN

 CREATE LOGIN [colorware] WITH PASSWORD='colorware', CHECK_POLICY=OFF

 SELECT 'login'

END

GO


IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = 'colorware')

BEGIN

 CREATE USER [colorware] FOR LOGIN [colorware]

 EXEC sp_addrolemember 'db_owner', 'colorware'

 SELECT 'user'

END

GO