locked
how can I move classifieds_Members to a ms sql server ? RRS feed

  • Question

  • User-23705340 posted

    Hi, I want to store my membership data on an ms sql server. How do I go about doing this ?.

    Thursday, July 10, 2008 1:13 AM

Answers

  • User-1212724461 posted

    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.

    <connectionStrings>

    <remove name="LocalSqlServer" />

    <add name="classifiedsConnection" connectionString="Data Source=.;Initial Catalog=Database_Name;Integrated Security=False; User ID=*****;Password=****" providerName="System.Data.SqlClient" />

    <add name="LocalSqlServer" connectionString="Data Source=.;Initial Catalog=Database_Name;Integrated Security=False; User ID=*****;Password=****" providerName="System.Data.SqlClient" />

    </connectionStrings>

     

    Hope this was what you where looking for. Please mark this post as answered if this solves your problem.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, July 17, 2008 8:41 AM

All replies

  • User-1705717250 posted

    Well for starters I would take a read of

    http://aspnet.4guysfromrolla.com/articles/120705-1.aspx

    and

    http://www.asp.net/learn/security/

    Hope it what you are looking for

    Thursday, July 10, 2008 12:20 PM
  • User730446648 posted

    I too chose to work with mssql databases.

    But specifically how to depends on who your host provider is.

    I chose godaddy, and I am fully up and running.

     

    Thursday, July 10, 2008 6:04 PM
  • User-23705340 posted

    What I want to do is set it up so that I can use Web Site Administration Tool to administer the site.

    If I change the connectionStringName in the web.config file the Web Site Administration Tool shows the local users and under Providers it says " No providers created ".

    If I remove AspNetSqlMembershipProvider and memebership from the web.config file it still uses the details in the local database and under Providers it shows <label for="ctl00_ctl00_ctl00_content_content_content_ProviderList_ProviderListGridView_ctl02_ProviderRadioButton">AspNetSqlProvider</label>, even though there's nothing in the web.config file.


    Thursday, July 10, 2008 7:06 PM
  • User-23705340 posted

    Hi darknight, how's things ?.

    How did you manage to get your membership table across to godaddy ?.


    Thursday, July 10, 2008 7:16 PM
  • User730446648 posted

    It don't have time to go over it right now, but I have in the past several times.

    Do an advanced search for all of my post with godaddy as the search term.

     

    FYI, to do an advanced search of the forum, you just click on the magnifying glass in the top right of this page with nothing in the textbox.

    Then enter my username

    DarkKnight187

    Let me know if you need more help, and by the way I use two mssql databases.

    Thursday, July 10, 2008 9:20 PM
  • User-1705717250 posted

    How did you manage to get your membership table across to godaddy ?.

    You need to setup the database onto the hosted sql server. Many hosts do not support sql express databases in the an app_data.

    Take a look at these pages, seem to define the steps you need todo

    http://help.godaddy.com/topic/216/article/694

    http://help.godaddy.com/topic/216/article/689

    http://help.godaddy.com/topic/216/article/886

    Also you will need to make sure your applicationname is correct for the membership provider, take a read here

    http://weblogs.asp.net/scottgu/archive/2006/04/22/Always-set-the-_2200_applicationName_2200_-property-when-configuring-ASP.NET-2.0-Membership-and-other-Providers.aspx

    Hope it helps

    Friday, July 11, 2008 4:43 AM
  • User-1212724461 posted

    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.

    <connectionStrings>

    <remove name="LocalSqlServer" />

    <add name="classifiedsConnection" connectionString="Data Source=.;Initial Catalog=Database_Name;Integrated Security=False; User ID=*****;Password=****" providerName="System.Data.SqlClient" />

    <add name="LocalSqlServer" connectionString="Data Source=.;Initial Catalog=Database_Name;Integrated Security=False; User ID=*****;Password=****" providerName="System.Data.SqlClient" />

    </connectionStrings>

     

    Hope this was what you where looking for. Please mark this post as answered if this solves your problem.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, July 17, 2008 8:41 AM