SharePoint Foundation 2010 using local accounts

SharePoint Foundation 2010 using local accounts

Posted by richard | March 12, 2012 | SharePoint, TFS 2012

image

When configuring Team Foundation Server 11, the default action is to install and configure SharePoint Foundation 2010. I think this is great. I really love SharePoint 2010, and am glad that Microsoft opted to install the newer version automatically, rather than WSS3 like it did previously. Keep in mind that WSS3 will still work with TFS11 and even has a smaller RAM requirement as well.

After installing the SharePoint prerequisites, I proceeded to the installation and then to the configuration wizard. When I got to the step where I was asked to specify the Database Access Account, I assumed my local windows account would work fine. In fact, if you read the fine print below it says “If your configuration database is hosted on another server, you must specify a domain account”. Mine’s not. I’m creating a VM with an all-up image to be used in an environment that doesn’t have a domain.

image

But SharePoint wasn’t having it. I got the message that The specified user VSTFSSPSERVICE is a local account. Local accounts should only be used in stand alone mode:

image

This messages makes it a bit more clear, but since this guidance contradicts the TFS guidance I’m following in the TFS11 installation guide, I needed to find another way. Fortunately, I found this Microsoft workaround posted by Neil “The Doc” Hodgkinson. Here are the steps from that I followed:

  1. Canceled out of the the configuration wizard.
  2. Launched the SharePoint 2010 Management Shell.
  3. Ran New-SPConfigurationDatabase.
  4. Entered SharePoint_2010_ConfigDB for the DatabaseName.
  5. Entered VSTFS for the DatabaseServer.
  6. Entered the username and password for the Database Access Account into the dialog. Note: this account is also known as the server farm account and requires certain permissions.
  7. Entered a valid passphrase.

After a few moments, SharePoint created the a new configuration database and an admin content database for me:

image

Next, I launched the SharePoint 2010 Products Configuration Wizard again and it picked up right where I would expect it to:

image

#ProblemSolved

Related Blogs

Posted by richard | November 6, 2013
SharePoint 2013 support for Windows Server 2012 R2
UPDATE (14 March 2014) - As a few of you have pointed out, Service Pack 1 for Microsoft SharePoint Server 2013 is now available. Wanted to share a surprise impediment from...
Posted by richard | October 7, 2013
The One Work Item check-in policy
Thanks to my fellow Visual Studio ALM MVP Colin Dembovsky for building the “One Work Item” check-in policy that I was always too lazy to build. Judging by the title,...
Posted by Simon Reindl | March 14, 2013
Rename a TFS Project Collection
I was asked the other day how to rename a Team Project Collection. There is a way, and it is more like a three card shuffle than anything else, and...