Complete Single Server SharePoint 2010 installation using local accounts
In SharePoint 2007 we could choose a single server installation (which installed SQL Server express) or a Farm installation (which uses SQL non express). It was possible to use local accounts for the Farm Installation too.
In SharePoint 2010 we can’t use local accounts for the Farm Installation. However if you choose for single server installation you get SQL Server Express 2008. To Fix this on a development environment I came to the blogpost of Neil 'The Doc' Hodgkinson: http://sharepoint.microsoft.com/blogs/fromthefield/Lists/Posts/Post.aspx?List=0ce77946%2D1e45%2D4b43%2D8c74%2D21963e64d4e1&ID=112&Source=http%3A%2F%2Fsharepoint%2Emicrosoft%2Ecom%2Fblogs%2Ffromthefield%2FLists%2FPosts%2FAllPosts%2Easpx
This method worked for me on the public beta. The steps I followed:
- Choosed the farm installation method
- Didn’t run the configuration wizard directly after installation
- Installed SQL Server 2008 SP1 Fix: KB970315 x64
- Restarted IIS (If not I got problems in the following steps)
- Start Menu >> Microsoft SharePoint 2010 Products >> SharePoint 2010 Management Shell
- You get a SharePoint 2010 Management Shell (PS C:\Users\Username)
- Type: New-SPConfigurationDatabase
- DatabaseName: SharePoint_2010_ConfigDB
- DatabaseServer: e.g. DEV (It’s your computername)
- Now your prompted for the Farm Credentials. Please insert them
- The last step in insert a Passphrase: you can choose some of your own
- After this completes you will find in SQL a new configuration database and an admin content database
- Run the SharePoint Products Configuration Wizard
- Choose: Do not disconnect form this server farm (it takes your config database and database server automatically)
- Follow the other steps in the wizard
Note: For development environments only. Don't use this at a production environement. Set your password expiration to 0 days (never).