ASPNETDB Management Agent for FIM2010?
Hi Guys, has anyone seen, or is working on a Management Agent for FIM2010 that will connect in with the classic ASPNETDB? FIM is on my radar to evaluate for managing our SharePoint2007 based Extranet and we currently have a mix of ADAM, ASPNETDB and (when it's going) Federated Services based users. I'd like a unified way to manage them and for the users to be able to self-service (the latter currently provided by some nice tools from BambooSolutions). ThanksCraig
March 29th, 2010 3:48am

Hi Craig! Since ASPNETDB is an SQL Server Database you should be able to use SQL MA, if not directly because the database schema doesn't fit the SQL MA probably through a custom view or by using instead-of triggers on the view. More about SQL MA here and here //HenrikHenrik Nilsson Blog: http://www.idmcrisis.com Company: Cortego (http://www.cortego.se)
Free Windows Admin Tool Kit Click here and download it now
March 29th, 2010 10:05am

Hi Henrik, thanks for that, I hadn't come across it in the FIM info. I presume the old MIIS functionality is still present in FIM? Will have to have a play! ThanksCraig
March 30th, 2010 12:43am

Yes, all the MIIS/ILM stuff is still available. You might try creating a view in aspnetdb and attaching the SQL connector to it (as Henrik said). I used the following in a demo that I had to do. Note that since it is a view you will have restrictions on how you could update it, but maybe it will get you started. In my case I only needed to read the data. Also I didn't specify an application name on the ASP side so it is hard coded here in the query. I also had the passwords set to be not encrypted in ASP (it was a demo). In a real situation you would have to use the same encryption logic in your ASP as in your sync rule to actually sync a password. SELECT aspnet_Users.UserName, aspnet_Membership.Password, aspnet_Membership.IsApproved AS Active FROM aspnet_Membership INNER JOIN aspnet_Users ON aspnet_Membership.UserId = aspnet_Users.UserId INNER JOIN aspnet_Applications ON aspnet_Membership.ApplicationId = aspnet_Applications.ApplicationId AND aspnet_Users.ApplicationId = aspnet_Applications.ApplicationId WHERE (aspnet_Applications.ApplicationName = N'/')
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2010 11:58am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics