Author: TJakobsen | Posted on: 4/3/2006 4:52:16 AM | Views : 423

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 ...