Creating a new ASP.NET membership provider

Creating a new ASP.NET membership provider

• Heniek

  Thanks A lot Gentleman. It really works.

  Regards

  
  
  

• IsoKake

  I love your book...  just what the newby to ASP.NET needs...  This post also anwsered my same question...  Thanks
  

• inge_03

  KAK:
  
  I am having the same problem. After installed SQL 2005 CTP, WSAT does not work, it keep telling me can not connect to database. I ran aspnet_regsql to create database and grant access to NT AUTHORITY\NETWORK SERVICE, but problem still exists..........
  Can someone tell me what's going on
  
  

• C#Shooter

  Wei Ming's suggestion does work. Howver, I tried it once without (I thought) success. Here's my experience, perhaps it will save you a day of headaches.

  Create the web.config file manually, if it's not already in your project. To do this, Add New Item toolbar button, Add New Item..., Web Configuration File, click the Add button. Then copy Wei Ming's XML between the <configuration...></configuration> tags.

  Open the WSAT. To do this, Website pull-down menu, then ASP.NET Configuration.

  Try the Security tab. If it does not succeed, try again. I had to do this, but the page finally popped up.

  Ahh, the sweet stench of success. Working this problem caused me to drink excessively and swallow an entire bottle of Tylenol ... Just kidding, but only barely.

  
  

• supermorph

  
  add the following script to web.config will solve this problem.....I found this solution in this forum
  
  
   <connectionStrings>
    <remove name="LocalSqlServer"/>
    <add name="LocalSqlServer" connectionString="Server=(local);Integrated Security=SSPI;Database=aspnetdb"/>
   </connectionStrings>
  
  

• javy_visual_studio

  Wayne,
  
  Try using the aspnet_regsql tool provided in the .NET framework. The aspnet_regsql.exe is located in c:\windows\microsoft.net\framework\<framework version>\aspnet_regsql.exe.
  
  If you run this exe without any parameters, it will execute a small Windows app that will walk you through creating the connection to the SQL server and add the appropriate tables for you.
  
  This is only part of the story though. Once this is done, I still don't know how to select this connection through the web site admin tool. I still get an error about attempting to connect to SQL Server Express. Once you go through the wizzard, you will be able to see the new database and its tables in Enterprise Manager.
  
  Can someone elaborate on how to get the Web Site Administration Tool to use the provider configured with aspnet_regsql The help would be greatly appreciated.
  
  See http://msdn2.microsoft.com/library/83y98ckk(en-us,vs.80).aspx for more details on aspnet_regsql.
  
  Best regards,
  
  

• baci

  Wei Ming's method worked for me. except one thing he didn't mention, you will need to common out the original <connecttionStrings> ... </connectionStrings>
  

• IgorBabic

  I have the same problem.

  I have generated App Service Database with the name "Butikk" (did not use the default name aspnetdb), on my server OPS01\FULLSQL.

  My connection string :

  <connectionStrings>

  <add name="ButikkConnectionString" connectionString="Data Source=OPS01\FULLSQL;Initial Catalog=Butikk;Integrated Security=True"

  providerName="System.Data.SqlClient" />

  </connectionStrings>

  Why doesn't this string solve my problem I still can't choose Provider i Web Admin Tool. But I can se all the aspnet tables is created under my "Butikk" database. And the string is working properly to get data from my other tables under my database "Butikk".

  Please help !!

  
  
• Creating a new ASP.NET membership provider