Integrating SharePoint user profiles with forms authentication

George2
  • Integrating SharePoint user profiles with forms authentication George2

    I am using SharePoint Server 2007 Enterprise with Windows Server 2008 Enterprise. I have deployed a publishing portal. It is using a custom forms authentication solution, i.e. I store user names, passwords, and user profile information in a custom (schema) SQL Server database. I am developing using VSTS 2008 + C# + .Net 3.5 + ASP.Net + SharePoint Server 2007 SDK.

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

    BTW: I just care that the same profile values are displayed. There is no need to retrieve user profile data from my custom database, any other repository is ok.

  • There are some other solutions out there if you search on google, but if it were me, I would just use the bdc.

  • It isn't really possible to do what you describe - there is no "provider model" for the SharePoint profile store, meaning that the data has to be stored in SharePoint's profile store if you want to interact with it with SharePoint's profile API/management screens etc. Numerous features are predicated around this, such as the abilty to create custom profile fields (ish) and do audience targeting, and the current (2007) SharePoint architecture wouldn't be able to 'map' some of this functionality to a custom store.

    That doesn't mean to say you can't use the ASP.Net profile store if you choose - it's just that:

    • you're on your own in terms of user interface
    • you need to (obviously) use the ASP.Net membership API instead of SharePoint profile API
    • you forego certain things like audience targeting

    P.S. When 2007 was in beta I asked the feature owner for profiles (within the SharePoint Product Group) why the discrepancy between SharePoint/ASP.Net profile functionality. His answer was that it was just a lack of "join-up" between those 2 teams - slightly disappointing, but pretty inevitable when engineering a product as large as SharePoint..

  • From your description its a bit fuzzy exactly what you need, but if you want external data integrated into your MOSS User Profiles, this can be done using Business Data Catalog as a secondary data source for your user profiles. Read more on this techique here.

    There can be issues getting BDC working with FBA (BDC expects NTLM), but you should be able to work around this by extending the web application with another zone (see more details here)

    hth Anders Rask

    Futher reading: User Profile issue with FBA and SharePoint

Tags
user-profile forms-authentication
Related questions and answers
  • Possible Duplicate: Integrating SharePoint user profiles with forms authentication I am using SharePoint Server 2007 Enterprise with Windows Server 2008 Enterprise. I have deployed a publishing portal. It is using a custom forms authentication solution, which is described in the following URL. I am developing using VSTS 2008 + C# + .Net 3.5 + ASP.Net + SharePoint Server 2007 SDK. http://msdn.microsoft.com/en-us/library/bb975135.aspx My question is how do I implement a user profile function if I use such a membership provider? By user profile function I mean: a logged in user could

  • I am using SharePoint 2007 Enterprise + Publishing portal template + Windows Server 2008. And I am developing using ASP.Net + C# + .Net 3.5 + VSTS 2008 on SharePoint Server 2007. I am developing a custom authentication provider based on Forms authentication. When an anonymous access a page which needs authentication, by the default behavior, the login page will be redirected. My requirement is, when a user access a page for the first time in my SharePoint site which needs authentication, if there is a special URL variable in current http session called "Identity", I want to treat the user

  • After following Spence Harbar's Rational Guide to implementing SharePoint Server 2010 User Profile Synchronization (http://www.harbar.net/articles/sp2010ups.aspx) exactly (and having it work several... 22: The Forefront Identity Manager Service cannot connect to the SQL Database Server. This error now only exists once in the logs. The User Profile Sync service is now stuck at starting rather than...:02.06 OWSTIMER.EXE (0x04C4) 0x1398 SharePoint Portal Server User Profiles 9q15 High UserProfileApplication.SynchronizeMIIS: Failed to configure ILM, will attempt during next rerun. Exception

  • I am using SharePoint Server 2007 on Windows Server 2008. I am using Search Center to crawl web data source (i.e. crawl web page from other web sites). My question is related to crawled page counters displayed for the web data source log page of Search Center. My question is, there are 3 crawl counters displayed, successful counter, fail counter and warning counter. For each counter value... stored in Search Center? I am not sure whether there are any duplicated Urls in the 1000 counted pages? BTW: I have this confusion because I set daily incremental page crawl, for example, if http

  • I am using SharePoint 2007 Enterprise + Publishing portal template + Windows Server 2008. I am developing using VSTS 2008 + C# + .Net 3.5. I need to implement SSO (Single Sign On feature... am developing); If the value Identity variable is null, it means anonymous user. And if the Identity value is not null (means an authenticated user), I will using a WCF interface to find user information (e.g. user name and email address) from the Identity variable; The actual user name, user profile (e.g. email address) and password are maintained by the other site; My site will manage roles

  • I want to import user profiles in MOSS 2007 server into my SharePoint 2010 server. Can anyone please suggest how can i go about achieving the same. Can we import user profiles using Business Data Connection in Configure Synchronization Connection in User Profile Service Application in SharePoint 2010. Why i am doing this: I want to crawl MOSS 2007 User Profile Database in SharePoint 2010.

  • I am using SharePiont Server 2007 Enterprise with Windows Server 2008 Enterprise. I am developing using VSTS 2008 + C# + .Net 3.5. I am wondering whether SharePoint has any means to set an anonymous... using special connection string, like http://mysite/default.aspx?specialtestuser=foo,then I will set current anonymous to be foo.Appreciate if any code samples to reference? BTW: I am using Forms authentication, not sure whether in Forms authentication in SharePoint, there are any ways to set the anonymous user to someone based on some custom defined rules(e.g. IP address or http parameter)?

  • I am using SharePoint Server 2007 Enterprise with Windows Server 2008 Enterprise. I have deployed a collaboration portal template based SharePoint site collection. I am developing using ASP.Net web application using VSTS 2008 + C# + .Net 3.5 + ASP.Net + SharePoint Server 2007 SDK. I am devloping a custom Forms authentication component (a DLL) and wants to register it to be used in SharePoint sites. I heard for SharePoint Server 2007, custom Forms authentication can only be used for publishing portal and can not be used for collaboration portal. Is that true? thanks in advance!

  • I am using SharePoint Server 2007 Enterprise with Windows Server 2008 Enterprise, and I am using publishing portal template. I am using Insert Data View function from SharePoint Designer 2007 to insert a list created in parent site to a child site. Now the list displays correctly. My question is, how to hide the column name (displayed at the top of list content rows) in my child site (I want to show the list rows only, no need to show the list column name)?