More in this section

Forums / Developing with Sitefinity / Need example of multiple Sql membership providers

Need example of multiple Sql membership providers

2 posts, 0 answered
  1. chris_cf
    chris_cf avatar
    32 posts
    04 Jul 2007
    28 Feb 2009
    Link to this post

    I am unable to get multiple providers to work.

    I have 2 databases. One contains the CMS data and the users that will administer the site. The other contains the users of the web application front end.

    I have tried adding this to the <providers> section under <roleManager>:
    <add connectionStringName="conn_IPayData" applicationName="/" name="IPay" type="Telerik.DataAccess.AspnetProviders.TelerikRoleProvider, Telerik.DataAccess" />

    But i keep getting this error:

    No connection with the name of "conn_IPayData" was found.

    But the connection is clearly defined in my <connectionStrings> section:

    <add name="conn_IPayData" connectionString="Data Source=DEVSERV;Initial Catalog=IPay;Persist Security Info=True;User ID=ipay;Password=me2d92" providerName="System.Data.SqlClient" /> 

    An example of how to use multiple providers for Sql would be greatly appreciated.
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    12 Sep 2017
    01 Mar 2009
    Link to this post
    Hi chris_cf,

    Please add a new connection under <dataAccess> node under your web.config file as the example below demonstrates:

      <dataAccess defaultConnection="DefaultConnection">  
          <add name="CustomConnection" driver="Nolics.ORMapper.DataProviders.SqlServer2005Provider" 
         connectionStringName="MyCustomConnection" /> 
         <add name="DefaultConnection" driver="Nolics.ORMapper.DataProviders.SqlServer2005Provider" 
          connectionStringName="Sitefinity" /> 
         <add name="GenericContentConnection" driver="Telerik.Cms.Engine.Data.Providers.GCSql2005Provider, Telerik.Cms.Engine.Data" 
          connectionStringName="Sitefinity" /> 

    For connectionStringName set the name of your connectionstring which you have defined under  <connectionStrings> section. If you use MySql, not SqlServer, change the driver( it should be set in your web.config)

    Ivan Dimitrov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
2 posts, 0 answered