My Experience Setting Up TFS\Windows Sever\SQL Server 2008

VSTS Links - 11/04/2008

Team System News — Tue, 04 Nov 2008 16:00:35 GMT

The Developer Support Team Foundation Server Blog on My Experience Setting Up TFS\Windows Server\SQL...

VSTS Links - 11/10/2008

Team System News — Mon, 10 Nov 2008 17:48:51 GMT

The Developer Support Team Foundation Server Blog on My Experience Setting Up TFS\Windows Server\SQL...

re: My Experience Setting Up TFS\Windows Sever\SQL Server 2008

Lonnie — Wed, 19 Nov 2008 22:54:48 GMT

I followed the Installation guide very carefully for a TFS 2008, SQL 2008, Server 2008 install but Issue 3 was driving me crazy... event log entries started with messages about not having MDAC installed??, login failures with different accounts, etc... I tried adjusting security on the service accounts in SQL server and nothing would work.

Finally found this blog, added NETWORK SERVICE to TfsWarehouse as suggested and reports started working... yea! In addition, once this was done I wasn't seeing any of the errors that I would get with previous attempts at running the Warehouse service.

Thanks for the Info! It would also be great if this was added to the Install Guide to prevent others from running into the same issue.

Thanks!

re: My Experience Setting Up TFS\Windows Sever\SQL Server 2008

ShivKumar — Fri, 21 Nov 2008 13:25:26 GMT

I am also facing the same issues, I have tried all the possible security related permission but nothing has helped me. Finally I have seen this blog, had some hope to resolve this issue. As you said, I ran the script but unfortunately I was not able to resolve this issue. Could you please help me out.

The TFS deployment details are below.

* Dual Server Deployment

* SQL Server 2005

* SSAS was deployed in a remote server (not in database server).

The actual error I am getting is

TF53010: The following error has occurred in a Team Foundation component or extension:

Date (UTC): 11/20/2008 12:29:20 PM

Machine: <machine Name>

Application Domain: /LM/W3SVC/1043077123/Root/Warehouse-6-128716562250781250

Assembly: Microsoft.TeamFoundation.Warehouse, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727

Process Details:

Process Name: w3wp

Process Id: 4732

Thread Id: 5392

Account name: <domain>\<user>

Detailed Message: The pending configuration changes were not successfully added to the cube because of the following error: Microsoft.AnalysisServices.OperationException: Internal error: The operation terminated unsuccessfully.

OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.; 42000.

Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'TfsWarehouseDataSource', Name of 'TfsWarehouseDataSource'.

Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Load Test Counter Dimension', Name of 'Load Test Counter Dimension' was being processed.

Errors in the OLAP storage engine: An error occurred while the 'Counter ID' attribute of the 'Load Test Counter Dimension' dimension from the 'TfsWarehouse' database was being processed.

Server: The operation has been cancelled.

re: My Experience Setting Up TFS\Windows Sever\SQL Server 2008

CSSTFSBLOG — Fri, 21 Nov 2008 22:57:10 GMT

ShivKumar,

I would try the following article:

http://support.microsoft.com/kb/951756

MMJ

re: My Experience Setting Up TFS\Windows Sever\SQL Server 2008

Dhattel — Wed, 10 Dec 2008 19:59:30 GMT

I can't find Team Explorer 2008 SP1 anywhere. Can you tell me where I can get it?

re: My Experience Setting Up TFS\Windows Sever\SQL Server 2008

CSSTFSBLOG — Wed, 10 Dec 2008 20:12:31 GMT

TE SP1 is actually part of Visual Studio 2008 SP1 - it is not its own download or package. You can find VS 2008 SP1 here: http://www.microsoft.com/downloads/details.aspx?familyid=FBEE1648-7106-44A7-9649-6D9F6D58056E&displaylang=en

- Trevor Hancock

TFS2008 on Windows Server 2008 and SQL Server 2008

Posts from the province — Thu, 11 Dec 2008 16:52:02 GMT

Today I decided to create a TFS 2008 VPC environment using Windows Server 2008 and SQL 2008. In general

re: My Experience Setting Up TFS\Windows Sever\SQL Server 2008

Greg — Tue, 16 Dec 2008 14:18:16 GMT

Many, many thanks for posting this. I'd tracked my reporting issue down to a database login issue on TfsWarehouse, your post saved me a lot of time working out what was going on from there!

Workaround for TF30207 when creating a new team project and red X on Reports in Team Explorer

Visual Studio Team System (VSTS) Blog - by Neno Loje — Fri, 09 Jan 2009 01:45:15 GMT

Problem description : You can't create new team projects. You see a red X on Report in Team Explorer

re: My Experience Setting Up TFS\Windows Sever\SQL Server 2008

Neno — Fri, 09 Jan 2009 01:46:25 GMT

Verify your ReportServerUri path - tfsadminutil has a bug in TFS 2008 SP1 and that can cause the TF30207 and the red X on Reports!

-Neno

How to fix TF53010: Create OLAP failed

Visual Studio Team System (VSTS) Blog - by Neno Loje — Fri, 09 Jan 2009 01:50:48 GMT

Problem description : After a clean install of TFS 2008 SP1 I was wondering about this message in the

re: My Experience Setting Up TFS\Windows Sever\SQL Server 2008

Benjamin — Tue, 17 Feb 2009 14:38:47 GMT

First I installed Visual Studio on the clients and after that SP1 and THEN Team Explorer.

Than I installed TFS2008 on a virtual server but I got the red x problem with Reports and I was not able to create a new Team Projekt on a client machine although I've got enough rights and permissions to do that.

Ive searched a lot but without success.

The problem was that I first installed the Visual Studio SP1 and after that the Team Explorer, you have to do this contrariwise because the SP1 updates some files of the Team Explorer.

After reinstalling the SP1 it works fine for me, I'm now able to create new Team Projects and the red x problem disappeared.

Greets

re: My Experience Setting Up TFS\Windows Sever\SQL Server 2008

Steve — Wed, 17 Jun 2009 13:46:39 GMT

Many thanks, I'd made my way through most of your list before finding it on the reports problems.

Saved me a heap of time! Not having fun.

re: My Experience Setting Up TFS\Windows Sever\SQL Server 2008

Amir — Thu, 13 Aug 2009 14:34:27 GMT

Tanks alot and alot. But I need more help.

I had a problem about Reporing (TFS Reporting not work). I follow a method which descripted in this post:

http://blogs.microsoft.co.il/blogs/shair/archive/2009/06/25/cannot-open-database-quot-tfswarehouse-quot-requested-by-the-login.aspx

I do all of works exactly except one! In MS SQL Server Managemenet Studio I set '[ServerName]\TFSService' schema as owned by user dbo. Then I found my mistake (I should set Network Service instead) but I could not uncheck this item again, so I went to the Schemas and set schema owner for [ServerName]\TFSService schema to [ServerName]\TFSService user.

But TFS reports shows the same error message again.

Would you please help me? I thinks its better to reinstall clean windows and setup TFS again.

re: My Experience Setting Up TFS\Windows Sever\SQL Server 2008

Trevor Hancock — Thu, 13 Aug 2009 17:35:35 GMT

We would be glad to help Armin, but I'll have to ask you to call us at support. You can start here: https://support.microsoft.com/oas/default.aspx?gprid=10453&st=1

re: My Experience Setting Up TFS\Windows Sever\SQL Server 2008

Amir — Thu, 13 Aug 2009 22:47:38 GMT

Tanks Trevor again,

I solved it! The point was this:

Connecting to Analysis services> database > tfswarehouse > roles > set the tfswarehousedatareader role permissions to full control process database!

Thanks

re: My Experience Setting Up TFS\Windows Sever\SQL Server 2008

Dimitris Staikos — Fri, 04 Sep 2009 12:34:23 GMT

Thanks man! You rule!!!

What a great 'experience' doing the TFS2008+SQL2008 installation... So straightforward... Were it not for the VM snapshots I would have jumped off a cliff by now :P

Now I still have this guys' problem http://social.msdn.microsoft.com/Forums/en-US/tfsreporting/thread/440e0f48-245a-4c28-9a5d-ed8a309845cb (Bugs found without corresponding tests Report not working (Hotfix KB969210 applied)) but I am sure I'll get over it somehow.

re: My Experience Setting Up TFS\Windows Sever\SQL Server 2008

Trevor Hancock — Fri, 04 Sep 2009 17:32:52 GMT

Ah shucks. :-)

That final issue with the "Bugs found without corresponding tests" report is caused by a SSRS issue, not one with TFS. It actually should not happen any more if you have at lease one BUG in your team project. Or, you can apply the fix in this KB and that should clear it up too, regardless of how many BUGS are in your TP: http://support.microsoft.com/kb/969235.

Loop back and let me know what you do and the results. I'll get this info added to OUR article too.

TrevorH