Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I had to restore a TFS 2010 virtual machine and am having trouble getting WSS running. When I try to go to the Sharepoint Admin portal localhost:17012 it fails. In the event viewer I see a bunch of

SQL database login failed. Addition error information from SQL Server is included below.

Login failed for user 'TFS\TFSREPORTS'

TFS\TFSREPORTS is a local user (running in a workgroup not a domain). How can I re-establish this user as an appropriately permissioned user for WSS?

share|improve this question
up vote 1 down vote accepted

You need to create a login for the TFS\TFSREPORTS login into the SQL Instance, as well as correct the rights to the databases if needed.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.