Author: bbxrider | Posted on: 4/6/2010 6:09:03 PM | Views : 496

the error i'm getting after moving the aspnetdb db for the login control from vs to my iis for testing, see below for how i made the move

attach the vs2005/app_data db to the sql express studio, there you can add the myMachine/aspnet user to the sql security users and then the users for the db, and give it  db_datareader and db_datawriter permissions. then make sure that both the aspnetdb.mdf and its aspnetdb_log.ldf files have r+w permission for the aspnet account. then copy both files to app_data directory under the application folder in iis.
the machine.config dbproviderFactory setting is
<add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
      <add name=&quo ...

Go to the complete details ...