Hi,

I've got my website working on my computer alright, at the stage of publishing it, but I can't figure out how to create all the tables for memberships. I've turned off default membership connection, managed to write a connection string for the db that's got my custom tables, all is working fine...

  <connectionStrings>
    <add name="mydbConnectionString" connectionString="Data Source=mssql1.openhost.net.nz;Initial Catalog=mydb;User ID=****;Password=****;"  providerName="System.Data.SqlClient"/>
    <remove name="LocalSqlServer"/>
  </connectionStrings>

 but need to enable membership and that's just not working without the tables, esp. that I have allowAnonymous="true"....

I'm sure it's pretty common, but would someone please point me to the right direction? I have access to MySQL and Microsoft SQL Servers...

Much appreciated,

 Alexi

did you actually have all tables for membership in your database ?

if not are you planning to use default aspnet membership schema ?? if yes .. check this how to do that .. http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

if not do let know exactly what and how you are tyring to setup membership 

Hi,

 I had to connect to a remote server so was not sure how to do that. Thanks for the article - great help! At first was not able to run the Aspnet_regsql.exe (I have discovered that I have SQL server on my work laptop!!!) remotely, only to realize that I was behind the firewall. So I contacted them, and they allowed my ip to connect, after that it was all sweeeeeeeeet.

With a bit of playing around it all worked out. Thanks for your help, trully. 

  <connectionStrings>
    <remove name="LocalSqlServer"/>
    <add name="LocalSqlServer" connectionString="Data Source=mssql1.openhost.net.nz;Initial Catalog=mydb;User ID=****;Password=****;"  providerName="System.Data.SqlClient"/>
    

  </connectionStrings>

Cheers,

Alexi