19. March 2013 23:19
I get the following error when I attempt to view reports:
An error has occurred during report processing. (rsProcessingAborted)
Cannot impersonate user for data source 'TfsReportDS'. (rsErrorImpersonatingUser)
Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Verify that the password for the account reporting services is using has not expired.
In your browser, navigate to http://localhost/reports (from your reporting server machine).
Click on Tfs2010ReportDS on the home page. Under the 'Credentials stored securely in the report server' click the Test Connection button. You should see the following message "Log on failed. Ensure the user name and password are correct."
Simply reenter the username and password information and test the connection again.
27. May 2010 19:39
I have to perform a migration many teams over to TFS and assign permissions to TFS, Report Server and SharePoint for dozens of Team Projects.
Use a batch file to set the permissions to all three locations at once.
TFSSecurity /g+ %1\Readers "[domain]\[user or group]" /collection:[tfs]\DefaultCollection
rs -i security.rss -s http://localhost/reportserver -v userName="[domain]\[user or group]" -v roleName="Browser" -v itemPath="/TfsReports/DefaultCollection/%1" -v keepCurrentPolicy="True"
stsadm -o adduser -url http://[tfs]/sites/DefaultCollection/%1/ -userlogin "[domain]\[user or group]" -role Contribute -username "Development Team" -useremail "developmentteam@[domain].com"
· %1 is a parameter to a batch file. The value passed into the batch file is the Team Project you want administer security over.
· All username or groups are in the domain\username format so replace [domain] with your domain and [user or group] with the username or group you wish to assign permissions too.
· [tfs] is the name of your TFS AT Server
Be sure that rs.exe, stsadm.exe and TFSSecurity.exe are on the machine you execute these commands from and are in the path. You must run the command prompt as Administer for the stsadm commands to succeed.
security.rss (2.47 kb)