I'm trying to configure ASP.NET2 Membership/roles/profiles and so on, to use a remote MSSQL 2005 server. I ran the aspnet_regsql.exe and it created the tables succesfully.
In my root web.config I got the following:
<connectionStrings>
<add name="webhotel" connectionString="Data Source=127.0.0.2; user id=XXX; password=XXX; Initial Catalog=XXX;"
providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
<roleManager enabled="true" />
<compilation debug="false" />
<authentication mode="Forms" />
<membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="15">
<providers>
<c ...
Go to the complete details ...