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