ASP.NET role management with SQL Server 2012

Question

After many attempts to use roles management in an ASP.NET project, I am in need of help.

I have a local SQL Server set up, and here are some parts of my web.config file...

<connectionStrings>
   <add name="DefaultConnection" 
        providerName="System.Data.SqlClient" 
        connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-WebSite2-20130703132914;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-WebSite2-20130703132914.mdf"/>
   <add name="SqlRoleManagerConnection" 
        connectionString="Data Source=my-pc;&#xA;Initial Catalog=aspnetdb;Integrated Security=SSPI;"/>
</connectionStrings>

<roleManager enabled="true">
  <providers>
    <add name="DefaultRoleProvider" 
         connectionStringName="DefaultConnection" applicationName="/"   
         type="System.Web.Providers.DefaultRoleProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
    <add name="SqlRoleManager" 
         connectionStringName="SqlRoleManagerConnection" applicationName="/" 
         type="System.Web.Security.SqlRoleProvider"/>
  </providers>
</roleManager>

The application is called WebSite.

aspnetdb is already set up on the local database and is ready to manage roles...

When I go to the ASP.NET configuration option in visual studio 2012 express, under security, it tells me that it cannot connect to the database.

I'm guessing the problem is in my web.config file, but I am not sure... Any help would be appreciated!

Win · Accepted Answer · 2013-07-03 21:21:23Z

1

You need to defaultProvider attribute. It says which provider you are going to use by default.

<roleManager enabled="true" cacheRolesInCookie="false" 
defaultProvider="DefaultRoleProvider">
  <providers>
    <clear/>
    <add connectionStringName="DefaultConnection" applicationName="/" 
name="DefaultRoleProvider" type="System.Web.Providers.DefaultRoleProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

    <add connectionStringName="SqlRoleManagerConnection" applicationName="/" 
name="SqlRoleManager" type="System.Web.Security.SqlRoleProvider"/>
  </providers>
</roleManager>

answered Jul 3, 2013 at 21:21

Win

62.4k13 gold badges106 silver badges190 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Feign Over a year ago

Okay, I will try this today!

Alexander · Accepted Answer · 2013-07-03 21:01:34Z

0

Do not configure two connectionStrings and two providers. If you must, configure which one is the default provider.

Read more: http://msdn.microsoft.com/en-us/library/ff647401.aspx#paght000013_step2

answered Jul 3, 2013 at 21:01

Alexander

2,4771 gold badge16 silver badges17 bronze badges

1 Comment

Feign Over a year ago

Okay I'll take out the one I don't need.

Collectives™ on Stack Overflow

ASP.NET role management with SQL Server 2012

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related