Use in production with SQL Server Authentication -- how?

Jan 31, 2012 at 6:18 PM

I'm setting up a SharePoint server with dual authentication as detailed at The integrated Windows authentication is working, and the SQL Server authentication is also working, using a database created by C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe. I've downloaded MyWSAT and set up another web site running it using the provided sample database on SQL Server 2008 R2.

The two databases look pretty similar; obviously the MyWSAT one has more stuff, but it appears to be a superset of the other. But no matter what I try -- Export, Copy, Attach and Rename, ... I can't get the SharePoint people picker to validate names from the MyWSAT database. How can I set up SQL Server authentication to use the sample database, or modify the working ddatab ase to be compatible with MyWSAT?

Jun 18, 2012 at 2:24 PM

Follow the steps here exactly:

Forms Based Authentication - SharePoint Claims Based Authentication Sites.

  1. Follow the instructions here:
  2. To implement a custom login screen see:

Good Luck!



Dec 9, 2012 at 7:02 PM

What if you aren't using SharePoint?  Instructions on moving this to SQL 2008 would be great and all the configurations that need to be done