Asp.net membership database

I am novice in asp.net and, I have design a website which is having small database (MS sql server), which is working fine on server but for users login, I have given asp.net membership security, which is not working, beca开发者_运维问答use its database is still in the app_data file. Now, how can I transfer membership database on my existing website's server.

First you have to setup the SQL Server Database to implement asp.net Membership. In order to do that you have to execute the aspnet_Regsql.exe found in C:\WINDOWS\Microsoft.NET\Framework\\aspnet_regsql.exe More information Here

Next you have to create the connection strings in your web.config to point to the right database for Membership.

Scott Guthrie has an older Blog post that explains the whole process

If you intend on using ASP.NET Membership security and your own database then you need to roll your own Membership class. See here for a step by step guide on how to do it.