ASPNETDB users not seen from Site Collection in Sharepoint WSS 3

Posted on 2007-10-06
Last Modified: 2009-12-16
Hello experts,

I'm using WSS 3.0 and trying to configure Forms Based authentication using ASPNETSQLMembership provider.  I have made changes to the web.config file in my application root and in the central admin root.  I have added users to my aspnetdb. I am able to browse those users in my database with the peoplepicker in my Central Admin site and I can resolve those users when I add them as site collection administrators.

My problem:  I cannot resolve users from my aspnetdb database from the people picker inside my site collection.  If I add a user from Central admin as a site collection admin, then I can login with that user.  If I try to add add'l users from the Site Collection settings pages, it does not see the users in my aspnetdb (only AD users).

Any help is appreciated.


Question by:soapygus
    LVL 25

    Expert Comment

    Are you prefixing the users with the DOMAIN\user?

    If so it's not necessary as FBA users aren't necessarily domain users.

    Author Comment

    Hey Robbie thanks for the input.
    I'm not prefixing users with Domain.  I'm still working on this.
    LVL 25

    Accepted Solution

    You will need to either develop a page by which to add users:

    See the users and role creation section.

    The other option is to add them directly to the DB.

    You could always let them register themselves using this web part:

    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
    A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now