Error Configuring Reporting Services in Team Foundation Server 2010 post install

Question

i try to configure SQL Server Reporting Services on an existing installation of TFS 2010

After configuring the Warehouse, Analysis Services and Reports tab in the TFS Administration Console, I get the following error: "Failed to add CORP\TFS-sharepoint WEB APPLICATIONS account to the TfsWarehouseDataReader role on the Tfs_Warehouse relational database."

please help

Answer 1

aajaamu,

Does your account, which you use to configure the Reporting Services, have enough rights to add an account to the TfsWarehouseDataReader role.

What you could try is to open the SQL Management Studio with the same account that you are configuring the TFS Reporting Services and connect to the SQL Server Database where the TFS_Warehouse database is and add that CORP\TFS-sharepoint account manually.

---

Please remember to mark the replies as answers if they help. --- Success, Damir

Answer 2

i added still i get the error.....

Answer 3

Hi,

Did you use the same account for the TFS Administration Console and the SQL Management Studio?

---

Please remember to mark the replies as answers if they help. --- Success, Damir

Answer 4

Hi aajaamu,

Thank you for your post.

Did you add BUILTIN\Administrators to TFS Service Accounts group? You can find it in TFS ADmin Console=>App Tier=>Group MemberShip.

Or Service Accounts for SharePoint Web Applications? TFS ADmin Console=>App Tier=>SharePoint Web Applications=> Service Accounts for SharePoint Web Applications.

A KB for you to refer: http://support.microsoft.com/kb/2025896

Would you please make the screen shot available, they will help narrow down the issue.

Best regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 5

Damir Varga,

i do use same account for both

the problem is i have no access to reportserver, so i ask my SQL developer who has access to both TFS Administration Console and the SQL Management Studio..stlllget that error

Answer 6

Answer 7

Hi aajaamu,

would you please post the detail event log?

And, the screen shot is t large, cannnot see the information detailly, would you please edit it more reabable?

thanks,

Answer 8

Please try this:

1. Go to Report server (either a dedicated / it can be your TFS App server if you have SSRS installed there).

2. Grant Farm/admin level access to TFSAdmin/TFSService account (assuming domain is similar for the user / server's domain or they have domain trust)..

3. Work with the DBA person and request them to grant you "SYSADMIN" database access for few minutes.

4. Go to SSRS (SQL Server Reporting Services configuration manager) and open it. Connect to the right instance and make sure all the header/sections listed on the

   left pane have valid values. NOTE: Sometime after the migration, you should first take the backup of existing encryption keys first, store it at a safe place on a drive and then delete the encryption keys (as you have taken the backup/copy, you can restore anytime if you need it but you won't require it). Delete the encryption key and restart IIS and SSRS client. Also, when you do this step, BACKUP/RESTORE option is not highlighted (during/just after migration, you see this in SSRS).

5. Make sure in SSRS each section/heading on the left pane of SSRS have valid values, this time you'll see Encryption key will have new key value.

6. Open SSMS (SQL Mgmt Studio), connect to both Database Engine and Analysis engine. If you see TFS_Warehouse and TFS_Analysis database under respective engines, you can add TFSAdmin/TFSService accounts inside those groups/role (TfsWarehouseDataReader/Admin role) that you requested at the top of this forum.

  Make sure the correct check box for access is selected i.e. readers should just have "read" box checked while TfsWarehouseDataAdmin/s should have more access than just read.

7. Open TFSAdmin console and see if everything looks fine or not. NOTE: If everything is fine, you still may have to rebuild both your TFS_Warehouse/TFS_Analysis databases again from scratch.

---

Arun Sangal Software Configuration Management Denver USA

Answer 9

Answer 10

Lily, Wu

 i don't see any BUILTIN\Administrators but i have TEAM FOUNDATION\team foundation administrators in which i can see BUILTIN\Administrators

i also added sharepoint service accounts to Service Accounts for SharePoint Web Applications

Answer 11

Hi aajaamu,

CORP\TFS-SharePoint is what account?

You are configure TFS Reporting service, why mentioned SharePoint Web Applications service account?

What account you use to configure reporting?

 

Answer 12

hi Mini,

TFS-sharepoint WEB APPLICATIONS account (This application group should only contain service accounts for SharePoint Web applications)

  i use the tfs-reports (report reader account) account to configure reporting services,should i need to use TFS service account (for accessing data sources)?

Answer 13

Hi aajaamu,

Please provide the detail event log, and detail configuration steps.

Do you use TFS-sharepoint WEB APPLICATIONS account anywhere during configuring reporting service? From the error log, it shows SharePoint do not add to databse, do you use this account as Reporting Services report reader account?

Use the Configure Reporting for Team Foundation Server page to opt in or out of using reporting. Select the Configure Reporting for use with Team Foundation Server check box to use reporting, or clear the check box to skip reporting, and then click Next.

• Type the name of the server that is running SQL Server Reporting Services in Reporting Services Instance and click Populate URLs. The URLs for the report server and its management site appear in the drop-down lists for Report Server URL and Report Manager URL.
• Ensure the values displayed are the URLs that you want to use for Team Foundation Server and click Next.
• Type the name of the server that is running SQL Server Analysis Services in SQL Analysis Services Instance and click Next. To test the connectivity to SQL Server, you can optionally click Test.
• Type the name and password of the report reader account (TFSREPORTS), and click Next. If you specified a user account for the service account of Team Foundation Server in step 4, you must select the Use a different account than the Team Foundation Server service account for the Reporting Services report reader account check box to use a different account. To test the user account and password combination, you can optionally click Test.

Answer 14

hi jacson,

  I am new to this client , they already installed tfs on a server with reporting and sharePoint web application but they didn't configure reporting services

I try to configure with the following steps

1. click reporting on application tier and click on edit

2. click on check box use reporting

3.warehouse: servername: sql81

                       database: tfs_warehouse

4.analysis: servername: sql81

                 database: tfs_analysis

                 username: tfs-reports password: xxxxx

5. reports: servername: sql81

                 i couldnot populate urls because i dont have admin acess to SQL81 server but i manually filled URLS for reportserver

                username: tfs-reports password:xxxxx

CLICK OK

i get "Failed to add CORP\TFS-sharepoint WEB APPLICATIONS account to the TfsWarehouseDataReader role on the Tfs_Warehouse relational database."

Answer 15

Hi aajaamu,

The TFS reporting service has already configured, else when you open TFS administration console--Application Tier--Reporting, the page information promot you configure reporting. Now, you can click Edit, means the reporting service has been configured.

The problem may relate to SharePoint.

This case is too long now, why not post a new question, some other microsoft guys and other members may jion in.

Answer 16

HI MINI,

i get this error when i am trying to reconfigure (edit) reporting services

should i need to ask DB admin to create a new database TFS_warehouse or TFS_Analysis or can i create THOSE DATABASES??????

please let me know as soon as possible

Answer 17

Hi aajaamu,

For urgent issue,  I suggest you to contact a Professional Support Service at http://support.microsoft.com/ to gain more support on this case.

Thanks,