Hi,

We have some problem with the report server after change the account of TFS

This error appears when we watch the raport.

Une erreur s'est produite lors du traitement du rapport. (rsProcessingAborted)

Query (3, 10) Analyseur : La syntaxe pour « = » est incorrecte.

Hi Xavier,

The accounts on the Report Server probably need to have their passwords also reset. You can follow the directions on this doc page about resetting passwords for TFS:

http://msdn2.microsoft.com/en-us/library/ms253149.aspx

let me know if that does the trick,

mauli

Hi Mauli

Thanks for your quick answer

I have reset the password with the TFSAdminUtils.exe but nothing has changed.
The same error appears always in the report viewer.

Hello Xavier,

These are the following places where the Report reader account is used.

- Report Server Data Sources.

- If you go to http://localhost/reports in your application tier yoiu will see both data sources there. Make sure that both of them are using the correct username and just in case re-type the password.

- TfsWarehouse Relational Role

- If you open the roles in TfsWarehouse relational database there is a reader role and the same account that is being used by the report server datasources should be added here.

- TfsWarehouse Cube Role

- If you open the roles in the TfsWarehouse cube database (Analysis Services) there is a reader role and the same account that is being used by the report server datasources should be added here.

- TfsWarehouse Relational _WarehouseConfig table.

- There is a bug in the release bits in TfsAdminUtil so if you run that utility to change the reporting account it doesn't update the following location so you need to do it manually. Open the _WarehouseConfig table in the TfsWarehouse relational database. There is a row for the DataReader property. You should change the value of that property to the proper account. The account will be used if you rebuild the cube and is the one that gets added to he reader role in the cube.

Please let me know if this helps.

Thanks.

Federico

I was pointed to this thread after I deleted the encryption key for reporting server and was trying to add the security settings again that were protected by the encryption key. I thought that what I found might be helpful so have included it here as well. The other thread can be found here:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=694847&SiteID=1

I had actually already found the majority of the settings that were removed, including the ones mentioned above. There was one last one that I only found today though...

It turned out to be the actual SQL Security Login for domain\tfsreports was missing. The TFSWarehouse Security Role for domain\tfsreports was there, and it was included as part of the TFSWarehouse Database role TfsWarehouseDataReader. So basically all the security settings as set out in the previous post were already correct.

Also one thing I noticed: in the TFSWarehouse Cube, the Role TfsWarehouseDataReader has its membership for an SID, not the user name. When I tried to enter the domain\tfsreports user it gave me an error [The following system error occurred:  No mapping between account names and security IDs was done. .
 (Edit Role - TfsWarehouseDataReader)]. I figured out that the SID is actually for domain\tfsreports using the great tool, psgetsid.exe.