Try Now
More in this section

Forums / Set-up & Installation / Membership Stored Procedures

Membership Stored Procedures

2 posts, 1 answered
  1. Jimmy
    Jimmy avatar
    3 posts
    04 Jul 2012
    26 Oct 2010
    Link to this post
    Hi All!

    I've had a quick search of the developer network sub-sites for an answer to this, but I've come up short!

    We are running Sitefinity 3.7 SP4 .NET 3.5 on Windows Server 2008 (not R2) with IIS7 and SQL Server 2008, and have multiple applications that require a shared membership provider (SSO essentially).

    We need Sitefinity to use the default ASPNET Membership, Role (and perhaps Profile?) providers, which I have changed in the web.config and I have created the necessary records for Users, Roles, Applications etc etc.  The problem we have is that the stored procedures (and there are something like 30 "telerik_" procedures) all reference the modified User/Membership table setup (Membership doesn't even exist in the Sitefinity database).

    Some of the stored procedures are easy to fix to make it work, but anything User and Membership related is proving difficult with all of the joins and the like.

    Has anyone been through this process and would be able to send me their altered stored procedures?


  2. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    01 Feb 2016
    27 Oct 2010
    Link to this post
    Hello Jimmy,

    Thank you for using our services.

    Sitefinity Membership, Role, and Profile providers derive from the ASP.NET membership providers. If you are using custom ones then your providers should create their own tables and use their own stored procedures for handling data. This will also ensure that when your website is upgraded to a newer version of Sitefinity, Sitefinity will not "upgrade" its built in stored procedures and roll back the changes you have made to the tables and stored procedures.

    Sincerely yours,
    Radoslav Georgiev
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
2 posts, 1 answered