More Team Foundation Server Voodoo

After finally getting TFS installed I went to create my first project under it and was greeted with a new lovely error message:

TF30004: The New Team Project Wizard encountered an unexpected error while initializing the Microsoft.ProjectCreationWizard.Reporting plug-in.

TF30171: The Microsoft.ProjectCreationWizard.Reporting plug-in used to create the new team project could not be initialized and returned the following error: TF30224: Failed to retrieve projects from the report server. Please check that the SQL Server Reporting Services Web and Windows services are running and you have sufficient privileges for creating a project..

After alot of googling and reading the primary solution came down to reinstall Visual Studio 2008 SP1 again which I put off figuring there had to be a less voodoo solution to this but eventually broke down and tried it. Surprisingly that fixed THIS problem and then immediately I was confronted with ANOTHER problem.

Trying to view the created project on Windows Sharepoint the first thing that shows up is:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source ‘TfsOlapReportDS’. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

More google hoop jumping which buried deep down in this post on How do I fix the TfsOlapReportDS user problem? I saw a comment from MattPil29

I had the same problem which was not solved by the “Allow log on locally” fix until I removed the same account from “Deny log on locally” !!!!

So I fixed that with:

NTRIGHTS -u TFSSERVICE -r SeDenyInteractiveLogonRight

Finally I have a successfully created Team Foundation Server project!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s