FBA and AspNetSqlMembershipProvider

I'm frustrating with this feature for three days and no success.

I'm using Sharepoint Server 2007.

Best I've achived system logs user but gives

Code Snippet

Error: Access Denied

Current User
You are currently signed in as: webadmin1

Sign in as a different user

I've created new web application, extended it with new one with extranet zone.

Added definition of sql connection string and AspNetSqlMembershipProvider in web.config of extranet and server administration websites. Administration website now see user from both ActiveDirectory and Sql DB.

Added webadmin1 with Full Access to web policy of Application.

Everything looks fine, but this access denied makes me smoking againSmile

Please, help meSmile

[1108 byte] By [SergeyOkhotny] at [2008-1-1]
# 1
Just to cover the 'duh' question (which has caught me too) - You have changed the affected site collection(s) site administrators to the FBA admin?
MarkAtDLC at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Setup, Upgrade, Administration and Operation...
# 2
I had this problem too..i could fix it...

Goto Central Administration >> Application Management >> Policy for Web Application

Click on ADD USER,

Now enter the User name here , click on " Check arrow" sign, Select its corresponding Zone and give this user FULL CONTROL...

Now try logging back in..it should work.

neeraj79 at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Setup, Upgrade, Administration and Operation...
# 3

neeraj79 wrote:
I had this problem too..i could fix it...

Goto Central Administration >> Application Management >> Policy for Web Application

Click on ADD USER,

Now enter the User name here , click on " Check arrow" sign, Select its corresponding Zone and give this user FULL CONTROL...

Now try logging back in..it should work.

Yes, I've done this - no luck, still access denied.

I think there is some security exception somewhere deep in SP. I'm receiving access denied event to anonymous user on SQL server, where sp db is.

SergeyOkhotny at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Setup, Upgrade, Administration and Operation...
# 4
Ok, the problem was that you have explicitly allow each user from AspNetSqlMembershipProvider to create MySites in Personalization services permissions
SergeyOkhotny at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Setup, Upgrade, Administration and Operation...
# 5

Where is Personlization services permission option located ?

I am still facing the same problem ... Is it anywhere in Central Administration ?

Neeraj

NeerajShah at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Setup, Upgrade, Administration and Operation...
# 6
In the shared service administration site go to Personalization services permissions in User Profiles and My Sites block
SergeyOkhotny at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Setup, Upgrade, Administration and Operation...
# 7

Sergey,

I have added my Active Directory user to "Personalization Services Permissions " and i have also given him full control in "Policy for Web Application "

But still i am getting Access Denied message. I have also given this user FULL CONTROL in my Site under " People and Groups "

this error is such a pain..

Any advise ?

Neeraj

NeerajShah at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Setup, Upgrade, Administration and Operation...

SharePoint Products and Technologies

Site Classified