Hi everyone,

Im creating a membership website in visual web developer 2005 express and im using the website administration function to set up my membership roles etc. so im using the default database thats created named aspnet.mdb found in the database explorer. does anyone know the code i put in the connection string in the web.config file to link the database to my pages so i can publish it to my website, im using vb code.

thanks

Lee

data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true

Hi leeplatt 

If you want to Configuring membership provider by connectionString, please  open the web.config file of publish website and add the following markup

<membership defaultProvider="mymembershipprovider">

  <providers>

    <clear/>

    <add name="mymembershipprovider"

         type="System.Web.Security.SqlMembershipProvider, System.Web,

          Version=2.0.0.0, Culture=neutral,

          PublicKeyToken=b03f5f7f11d50a3a"

         connectionStringName="LocalSqlServer"/>

  </providers>

</membership>

<connectionStrings>

  <add name="LocalSqlServer" connectionString="Data Source=sql2005;Initial Catalog=northwind;Integrated Security=True" providerName="System.Data.SqlClient" />

</connectionStrings>

Hope it helps