Category Archives: SharePoint 2010

SharePoint 2010 Foundation Forms Based Authentication

While setting up Forms based authentication I ran into this error:

The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentation and inspect the server trace logs.

Looking around I came across the following:

Go to your server’s IIS and open Sites | SharePoint Web Services | SercurityTokenServiceApplication.
Open that site’s web.config and add above the serviceMetadata element in the Behavior list.

Now when you login, you should get a more useful error. In my case it was:

You must specify a non-autogenerated machine key to store passwords in the encrypted format. Either specify a different passwordFormat, or change the machineKey configuration to use a non-autogenerated decryption key.

So I added new Machine keys to Admin, 80 and Web Services sites. Then it worked.


SharePoint Foundation 2010 Database

To connect to the SharePoint Foundation 2010 database through SQL Server Management Studio (SSMS), you need to use ‘SERVERNAME\Sharepoint’ if you have used the default express instance install. Alternatively, you can go to your Site Administration page, click on ‘Manage content databases’ under Application Management and click on the database name (WSS_Content). When the page loads, you should see the Database server listed.

For more info, see