VS 11 Role Management Not Going Through SQL Server RSS

• • Reply
  

  cjpanici

  Member

  4 Points

  21 Posts

  VS 11 Role Management Not Going Through SQL Server

  May 08, 2012 02:55 PM|LINK

  I have a Silverlight Business application and I am using Visual Studio 11 (.NET 4.5?).

  The only thing that I modified was the web.config file to point my user management to an existing database on the server. However, when I run my SL application the existing users in the database can not login. Also, I created a user in the application and it didn't show up in my database.

  My question is why is the application going through a different database when I run it in debug mode. I haven't tried publishing to IIS, because I should (theoretically) have the same result.

  Here is my web config:

  <?xml version="1.0" encoding="utf-8"?>
  <configuration>
    <configSections>
      <sectionGroup name="system.serviceModel">
        <section name="domainServices" type="System.ServiceModel.DomainServices.Hosting.DomainServicesSection,
                 System.ServiceModel.DomainServices.Hosting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" allowDefinition="MachineToApplication" requirePermission="false" />
      </sectionGroup>
    </configSections>
    <system.web>
      <httpModules>
        <add name="DomainServiceModule" type="System.ServiceModel.DomainServices.Hosting.DomainServiceHttpModule,
             System.ServiceModel.DomainServices.Hosting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
      </httpModules>
      <compilation debug="true" targetFramework="4.5" />
      <globalization culture="auto" uiCulture="auto" />
      <authentication mode="Forms">
        <forms name=".GolfPortal_ASPXAUTH" timeout="2880" />
      </authentication>
      <roleManager enabled="true" defaultProvider="DefaultRoleProvider">
        <providers>
          <clear />
          <add name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" applicationName="/" />
          <add name="DefaultRoleProvider" type="System.Web.Providers.DefaultRoleProvider, System.Web.Providers,
               Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="NeechSoftConnectionString" applicationName="/" />
        </providers>
      </roleManager>
      <profile defaultProvider="DefaultProfileProvider">
        <properties>
          <add name="FriendlyName" />
        </properties>
        <providers>
          <add name="DefaultProfileProvider" type="System.Web.Providers.DefaultProfileProvider, System.Web.Providers,
               Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="NeechSoftConnectionString" applicationName="/" />
        </providers>
      </profile>
      <membership defaultProvider="DefaultMembershipProvider">
        <providers>
          <add name="DefaultMembershipProvider" type="System.Web.Providers.DefaultMembershipProvider, System.Web.Providers,
               Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="NeechSoftConnectionString" enablePasswordRetrieval="false"
               enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6"
               minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="/" />
        </providers>
      </membership>
      <sessionState mode="InProc" customProvider="DefaultSessionProvider">
        <providers>
          <add name="DefaultSessionProvider" type="System.Web.Providers.DefaultSessionStateProvider, System.Web.Providers,
               Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="NeechSoftConnectionString" applicationName="/" />
        </providers>
      </sessionState>
    </system.web>
    <system.webServer>
      <validation validateIntegratedModeConfiguration="false" />
      <modules runAllManagedModulesForAllRequests="true">
        <add name="DomainServiceModule" preCondition="managedHandler" type="System.ServiceModel.DomainServices.Hosting.DomainServiceHttpModule,
             System.ServiceModel.DomainServices.Hosting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
      </modules>
    </system.webServer>
    <system.serviceModel>
      <serviceHostingEnvironment aspNetCompatibilityEnabled="true" multipleSiteBindingsEnabled="true" />
    </system.serviceModel>
    <connectionStrings>
      <add name="NeechSoftConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=NeechSoft;Integrated Security=True" providerName="System.Data.SqlClient" />
    </connectionStrings>
  </configuration>

  
  
  

  web sql login

• • Reply
  

  cjpanici

  Member

  4 Points

  21 Posts

  Re: VS 11 Role Management Not Going Through SQL Server

  May 08, 2012 03:19 PM|LINK

  OK, what I figured out is this: It looks like .NET 4.5 inserts user data into different tables than .NET 4.0. WHY?!?!?!?

  .NET 4.0 inserts user data into aspnet_Users and .NET 4.5 inserts into Users.

  Is there any way to change this?

  Thanks,

  neech

  web sql login

• • Reply
  

  sukumarraju

  All-Star

  16931 Points

  2999 Posts

  Re: VS 11 Role Management Not Going Through SQL Server

  May 08, 2012 03:53 PM|LINK

  Similar issue, which is outstanding

  http://forums.asp.net/t/1795988.aspx/1?VS+11+and+forms+authentication

  web sql login

  -- "Mark As Answer" if my reply helped you --
  Application Architecture Guide 2.0
  My Blog
  Twitter
  • Marked as answer by Frank Jiang - MSFT on May 22, 2012 10:40 AM
• • Reply
  

  cjpanici

  Member

  4 Points

  21 Posts

  Re: VS 11 Role Management Not Going Through SQL Server

  May 08, 2012 03:57 PM|LINK

  Thanks for the reply. The other horrible thing is that I can't go back to VS2010, because the installation of VS 11 broke my install of VS2010.

  Cursed,

  neech

  web sql login

• • Reply
  

  Frank Jiang ...

  All-Star

  16006 Points

  1728 Posts

  Microsoft

  Re: VS 11 Role Management Not Going Through SQL Server

  May 19, 2012 04:48 AM|LINK

  cjpanici

  OK, what I figured out is this: It looks like .NET 4.5 inserts user data into different tables than .NET 4.0. WHY?!?!?!?

  .NET 4.0 inserts user data into aspnet_Users and .NET 4.5 inserts into Users.

  Is there any way to change this?

  Why do not switch framework from 4.5 to 4.0 on VS11? I haven't used the VS11,but you can refer to the following steps:

  Change the Target .NET Framework

  You have to ensure that the .NET4.0 is installed on PC

   

  web sql login

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store