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:
Post a Comment