IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'CohesionDiscover')
CREATE LOGIN [CohesionDiscover] WITH PASSWORD = 'p@ssw0rd'
GO
CREATE USER [CohesionDiscover] FOR LOGIN [CohesionDiscover] WITH DEFAULT_SCHEMA=[dbo]
GO
GRANT CONNECT TO [CohesionDiscover]
CohesionDiscover