-- The following SQL will create a new "report only" account for use by EFT in SQL Server.
-- 
-- You will need to edit the following text in the script as you see fit:
-- <EFT_DATABASE_NAME>   - change this to the name of the database used by EFT within the SQL Server Instance
-- <EFT_REPORT_USERNAME> - change this to the desired username for the new EFT report user account
-- <EFT_REPORT_PASSWORD> - change this to the desired password for the new EFT report user account
--
-- This script may be run by pasting it into a SQL Server Management Studio SQL Query Window as 
-- an administrative account (e.g. "sa") and executing it. Alternatively, you may run it using the 
-- SQL Server command line interface using a command similar to:
-- sqlcmd -S localhost -U sa -P MyPassword -i SQLServerReportUser.sql

-- Create a login account to the SQL Server Instance for the new EFT report user database account
-- The following line will use SQL Server Authentication. To use Windows Authentication comment out this line 
-- and uncomment the next line.
CREATE LOGIN <EFT_REPORT_USERNAME> WITH PASSWORD = '<EFT_REPORT_PASSWORD>', CHECK_POLICY = OFF, DEFAULT_DATABASE = <EFT_DATABASE_NAME>;
-- CREATE LOGIN <EFT_REPORT_USERNAME> FROM WINDOWS WITH DEFAULT_DATABASE = <EFT_DATABASE_NAME>;

-- Create a database use account within the actual database and set his default schema to dbo.
USE <EFT_DATABASE_NAME>; CREATE USER <EFT_REPORT_USERNAME> FOR LOGIN <EFT_REPORT_USERNAME> WITH DEFAULT_SCHEMA = dbo;

USE <EFT_DATABASE_NAME>; EXEC sp_addrolemember 'db_datareader', <EFT_REPORT_USERNAME>;