Fols Scripts

--=====================================================
-- Author : FL
-- Date Creation : 2016-09-20
-- Description : Delete/Create SSRSAccount to be able to export report (PDF, XLS, ...)
--=====================================================
/**** delete user SSRSAccount ***/
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'SSRSAccount')
DROP USER [SSRSAccount]
GO

/**** create user SSRSAccount ***/
DECLARE @mainBase nvarchar(50)
DECLARE @login nvarchar(50)
DECLARE @sqlcmd NVARCHAR(4000)

SET @mainBase = LEFT(@@SERVERNAME, 15)
SET @login ='['+@mainBase + '\SSRS_Group]'
SET @sqlcmd='CREATE USER [SSRSAccount] FOR LOGIN '+@login

EXEC(@sqlcmd)
GO

EXEC sp_addrolemember N'FolsUsers', N'SSRSAccount'
GO