user profile issue with Forms Authentication and SharePoint

Question

Hello everyone,

I am using SharePoint Server 2007 Enterprise with Windows Server 2008 Enterprise. And I am using publishing portal. And I am using a custom Forms authentication solution -- I store user name and password in a custom (schema) SQL Server database. The database stores user profile information. I am developing using VSTS 2008 + C# + .Net 3.5 + ASP.Net + SharePoint Server 2007 SDK.

I want to learn how to program to integrate the user profile stored in database into SharePoint user profile management (so that from SharePoint all users information, I can click a link for a user and then the profile data stored in my database could be displayed)? Any feasible solution? Appreciate if some code samples which could be referred.

BTW: I just care the same value of profile be displayed, no need to retrieve user profile data from my custom database, any other repository is ok.

thanks in advance, George

Answer 1

You'll need to implement an ASP.NET Membership Provider. Basically you'll inherit from ProviderBase and to implement methods which will know to transform your custom schema in useful information for Sharepoint environment. This link can help: Implementing a Membership Provider

I suggest you to develop that custom provider in a regular ASP.NET site and, when you done, to install it at Sharepoint website.

EDIT: Take a look into this article series: Examining ASP.NET's Membership, Roles, and Profile. It's very complete.