Successfully Setting up SQL Forms Based Authentication for SharePoint Web Application

Hi there,

I’ve found my way here after many many hours of googling and article reading on the subject in the title.  Unfortunately no matter what article I follow I end up back at the same location again.  I’m sure I must be on the final steps of getting it working but at current all users get an access denied error after attempting to login.

I’ve got 3 usesrs in SQL,

admin1 = full control
fabsuperuser = full control
fbasuperreader = full read

I’ve run the powershell script to configure the users too…

$wa = Get-SPWebApplication -Identity “http://fba:8181”
$wa.Properties[“portalsuperuseraccount”] = “i:0#.f|aspnetmembership|fbasuperuser”
$wa.Properties[“portalsuperreaderaccount”] = “i:0#.f|aspnetmembership|fbasuperreader”
$wa.Update()

Still no joy.  I’ve run out of ideas to try.  Has anyone any ideas?

Nick