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?

link|improve this question

feedback

1 Answer

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

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