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.