How to Fix User Logins
Issue
Unable to run reports in Vista.
Error: "Downloading report template from server... Failed. Server-side error: see inner exception"
Solution
open SQL Server Management Studio and run the command:
ALTER USER vcsSSRS WITH LOGIN = vcsSSRS
or run the stored procedure:
USE Viewpoint GO sp_change_users_login 'AUTO_FIX','vcsservice' GO sp_change_users_login 'AUTO_FIX','vcsSSRS' GO