Last post Jul 20, 2009 10:33 AM by Taju
Jun 07, 2008 01:43 PM|sky_bobby|LINK
Plz. tell me how i can create aspnetdb.mdb database file in hosted sql 2005 server because in the classifieds starter kit , only script file for classifedsdb has been provided not for aspnetdb.mdb ..... also tell me how the connection string should be to
access aspnetdb file
Jun 07, 2008 04:45 PM|Mikesdotnetting|LINK
Using Access instead of Sql Server for membership is explained here:
Jun 07, 2008 05:27 PM|darkknight187|LINK
I use godaddy, and I set it up with two MSSQL databases.
The way godaddy has it setup, is when you create a database, it is automatically configured with the aspnetdb for the member info.
Ask your host provider if there is an option to set to use the database as a aspnet members database.
Jun 08, 2008 01:21 AM|sky_bobby|LINK
I m using quick2host.com which is a reseller of godaddy.com.... they have not provided me any information regarding to use the aspnetdb... whenever i try to create the ASPNETDB database, i get the error msg "cannot create the database because ASPNETDB database
already exits", but when i check the list of databases, there is not ASPNETDB database.
I dont know what to do? I have been trying to solve the problem since last week, but not successful... If u know how to use the ASPNETDB database on godaddy plz. tell me.
Jul 17, 2008 09:09 AM|jhmulder|LINK
Am not sure if this is what you are looking for:
I use MS-SQL database for the classiefieds starter kit. U need to setup a MS-SQL database with the classified tables (use the script that is provided.) i am using VS 2005. go to start->visual studio 2005 -> visual studio tools -> visual studio 2005 command
prompt. run the following command:
aspnet_regsql.exe -A all -sqlexportonly C:\runproviders.sql
this will create a script to setup the necessary tables and procedures in your database. the file is on C:\runproviders.sql.
open the file and replace all accurences of aspnetdb with your database name. now run the script. this will setup all the members tables on your MS-SQL database.
Now all you have to do is to create the correct connection strings in your web.config file.
Hope this was what you where looking for. Please mark this post as answered if this solves your problem.
Jul 20, 2009 10:33 AM|Taju|LINK
Hi If you are looking for the detailed explanation for how to create asp.net
membership provider database default name is aspnetdb. Look at this articles