To add user to ASAM
1) Create account
2) Add account and areacode relationship(s)

To add Sity client reports to a Client
1) Add Client SQLRS server account as "browser" to SityClient Reports folder.
2) Add Client SQLRS server account to the [AparcSystemsSpExecutor] role


NOTE:

Be sure all NEW procedures are added to the [AparcSystemsSpExecutor] role

To Add a SQLRS user
1) Create new machine/Windows account ("svcServiceAccount")
2) Add user to SQL server instance(s)
3) Add to:
i) AparcSystems with R/W permissions and AparcSystemsSpExecutor
ii) SityDb with R permissions
iii) SityDbxxxxx Client DB with R permissions and AparcSystemsSpExecutor
4) Add user account to SQLRS reports user param for Client via ASAM.