Hi, I have created an app using vb.net (webrole).
I want that this app use my database that is on the cloud, it's name is sgs, and want too, that my web security settings (asp.net configuration database) be on the cloud too.
( I don't want to use SQL Server installed on my machine)
I have read several papers about this issue.
They say that I need to create my database, whitch is already made, and that I need to create a second database that will store the user information.
This second database is also in the cloud already. I have used the tool aspnet_regsql to configure it.
So, I have a database, with the name SGS, and other database that I created and populated through the tool aspnet_regsql. This second database was named segurancas.
After creating the database I read that It was necessary to install Nuget package library and I done it.
Then, was you can see through my web.config file I changed the connection strings so they connect directly to the cloud.
The ApplicationServices is pointing to the segurancas database
and the default connection to my SGS database.
Still I can not configure security using asp.net configuration.
I keep receiving a message that my provider is not good.
Can you please help?
WebConfig file:
<!--
<configuration>
<system.diagnostics>
<trace>
<listeners>
<add type="Microsoft.WindowsAzure.Diagnostics.DiagnosticMonitorTraceListener, Microsoft.WindowsAzure.Diagnostics, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" name="AzureDiagnostics">
<!--
</add>
</listeners>
</trace>
</system.diagnostics>
<connectionstrings>
<!--
<add name="ApplicationServices" connectionstring="data soruce=mwjw08qhju.database.windows.net;initial catalog=segurancas;user id=pr;password=00yzw12ptag34_;encrypt=True;Trusted_Connection=false; multipleactiveresultsets=True" providername="System.Data.SqlClient" />
<add name="aspnet_1db0ca8ec36d4ba1852e5e4ec9947660Entities" connectionstring="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string="data source=.\SQLEXPRESS;initial catalog=aspnet_1db0ca8ec36d4ba1852e5e4ec9947660;integrated security=True;multipleactiveresultsets=True;App=EntityFramework"" providername="System.Data.EntityClient" />
<add name="SGSEntities" connectionstring="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string="data source=mwjw08qhju.database.windows.net;initial catalog=SGS;user id=pr;password=00yzw12ptag34_;encrypt=True;multipleactiveresultsets=True;App=EntityFramework"" providername="System.Data.EntityClient" />
<add name="DefaultConnection" connectionstring="Data Source=Server=tcp:mwjw08qhju.database.windows.net,1433;Database=SGS;User ID=pr@mwjw08qhju;Password=myPassword;Trusted_Connection=False;Encrypt=True;multipleactiveresultsets=True" providername="System.Data.SqlClient " />
</connectionstrings>
<system.web>
<authorization>
<allow roles="Administrador" />
<deny users="?" />
</authorization>
<compilation debug="true" strict="false" explicit="true" targetframework="4.0">
<assemblies>
<add assembly="System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
</assemblies>
</compilation>
<authentication mode="Forms">
<forms loginUrl="~/Account/login.aspx" timeout="2880" />
</authentication>
<membership defaultprovider="DefaultMembershipProvider">
<providers>
<clear />
<add connectionstringname="ApplicationServices" enablepasswordretrieval="false" enablepasswordreset="true" requiresquestionandanswer="false" requiresuniqueemail="false" maxinvalidpasswordattempts="5" minrequiredpasswordlength="6" minrequirednonalphanumericcharacters="0" passwordattemptwindow="10" applicationname="/" name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" />
<add name="DefaultMembershipProvider" type="System.Web.Providers.DefaultMembershipProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionstringname="DefaultConnection" enablepasswordretrieval="false" enablepasswordreset="true" requiresquestionandanswer="false" requiresuniqueemail="false" maxinvalidpasswordattempts="5" minrequiredpasswordlength="6" minrequirednonalphanumericcharacters="0" passwordattemptwindow="10" applicationname="/" />
</providers>
</membership>
<profile defaultprovider="DefaultProfileProvider">
<providers>
<clear />
<add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionstringname="ApplicationServices" applicationname="/" />
<add name="DefaultProfileProvider" type="System.Web.Providers.DefaultProfileProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionstringname="DefaultConnection" applicationname="/" />
</providers>
</profile>
<rolemanager enabled="true" defaultprovider="DefaultRoleProvider">
<providers>
<clear />
<add connectionstringname="ApplicationServices" applicationname="/" name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" />
<add applicationname="/" name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" />
<add connectionstringname="DefaultConnection" applicationname="/" name="DefaultRoleProvider" type="System.Web.Providers.DefaultRoleProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
<!--
</providers>
</rolemanager>
<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="DefaultConnection" applicationname="/" />
</providers>
</sessionstate>
</system.web>
<system.webserver>
<modules runallmanagedmodulesforallrequests="true" />
</system.webserver>
</configuration>
[Edit - removed pre tag from description, added pre tag for xml code block]