-- ===============================================
-- VersaSRS DATABASE
-- Grant permissions for Local DB Install
--
-- Examples:
--
-- <TRUSTEDACCOUNT> = [MACHINENAME]\ASPNET		(for Windows XP & Windows 2000)
-- <TRUSTEDACCOUNT> = [MACHINENAME]\IWAM_[MACHINENAME]	(for Windows 2000 Server - Domain Controller)
-- <TRUSTEDACCOUNT> = NT AUTHORITY\NETWORK SERVICE	(for Windows 2003)
-- 
-- Where [MACHINENAME] = your machine name
-- ===============================================

DECLARE @username sysname
SELECT @username = '<TRUSTEDACCOUNT>'

USE master
EXEC sp_grantlogin @username

USE VersaSRS
EXEC sp_grantdbaccess @username
EXEC sp_addrolemember N'db_owner', @username