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