Just sharing some of my inconsequential lunch conversations with you... RSS  

Saturday, February 14, 2009

Restoring a wounded Team Foundation Server

A couple of weeks ago I’ve tried to start a new project on our main TFS 2k8, just to find out it couldn’t be provisioned because of some kind of reporting services error.

After some digging I’ve found out the reason: our IT people decided to move the databases from the TFS server into a DB server, and since then we couldn’t create new projects. Well the databases should have been there on the first place, but the result was not the best, to say the least…

We are a software development shop, so this is absolutely unacceptable. For the last weeks we’ve been using our old TFS 2k5 and even Source Safe! Argh!…

The logs stated:

EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.



After some googling I’ve manage to find what was wrong: the IT people moved the databases and set the configuration accordingly, but missed setting the roles! Here’s what I’ve done:



USE [master]

GO

EXEC sp_addrolemember N'RSExecRole', N'Domain\User Service Account' -- SSRS Service Running

GO

USE [msdb]

GO

EXEC sp_addrolemember N'RSExecRole', N'Domain\User Service Account' -- SSRS Service Running

GO

 



And there it is, we finally recovered our TFS 2k8! Thanks to this link.

No comments:

Development Catharsis :: Copyright 2006 Mário Romano