Membership and SQL 2005

Discussion in 'ASP.NET / ASP.NET Core' started by Merv Norton, Jan 15, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I am trying to configure ASP.NET 2.0 Membership/ Roles Providers to use SQL 2005. I have followed the directions from the DiscountASP article and I followed the DiscountASP Webcast. I assumed that the command aspnet_regsql.exe -S DBServerName -U DBLogin -P DBPassword -A all -d DBName would be replaced by the connection string from the SQL Server 2005. It was not and I received an error.
    What am I missing?
    Additionally, when and where do I enter my password or is it picked up from my account?
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    I am not exactly sure what you meant by "DBName would be replaced by the connection string from the SQL Server 2005". Can you tell us exactly what you did? AND what is failing.
     
  3. Bruce,

    Since I did not receive any responces so I sent an email to DISCOUNTASP Support. I was sent the following connection string:

    aspnet_regsql.exe -S sql2k506.discountasp.net,14330 -U SQL2005_697202_brigade_user -P currentpassword -A all -d SQL2005_697202_brigade

    Which I ran this string, after I replaced currentpassword with my actual password, it ran successfully. I then tryed to Lognin on the web site and got an error message.

    You can visit my site, www.1stSigBdeAssn.org and use the user name of test and a password of sigbde#1 and see the error message.
     
  4. Bruce

    Bruce DiscountASP.NET Staff

    the error indicate the web.config is malformed. Try opening the web.config using VS.NET, it should tell you what's wrong.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page