Asp.net membership - sql authentication

Question

I want to know what the “right” way of setting up membership on a new website means.

When I have a new project, I can move on to setting up the website / ASP.NET. There I can configure forms authentication and manage all users who will use this page. I can create roles and rules in folders. All this information is stored in a table that will be saved locally in the App_Data / ASPNETDB.MDF database. What I'm trying to do is that all this information will be on the host server along with the website, but not locally.

What is the best way to connect my website, which I made locally on the mssql server, which is central. I want to be able to go to asp.net configuration and manage users, but I want the data to be stored in tables on the mssql server, and not in the aspnetdb.mdf file.

I already made asp.net membership tables on the mssql server using the aspnet_regsql.exe file.

Update: Nothing, I found out about it. It just needed to be added <remove name="LocalSqlServer"/> to <ConnectionStrings>, and then my own connection string. Now it works ...

Answer 1

SDK Visual Studio , "aspnet_regsql". , ASP.NET, SQL Server.

, , . , , , Visual Studio. , :

ASP.NET SQL Server:

• Visual Studio 2008.

  ( SQL- , , Visual Studio SDK.)

• aspnet_regsql .

• SQL, , :

  aspnet_Membership_FullAccess - aspnet_Membership_BasicAccess - aspnet_Membership_ReportingAccess -

• SQL :

  aspnet_Roles_FullAccess - aspnet_Roles_BasicAccess - asp.net

• SQL Server Management Studio:

  exec aspnet_Applications_CreateApplication @ApplicationName = 'Northwind', @ApplicationID = ''

  exec aspnet_Roles_CreateRole @ApplicationName = 'Northwind', @RoleName = 'Employee'

  exec aspnet_Roles_CreateRole @ApplicationName = 'Northwind', @RoleName = 'Manager'

  exec aspnet_Roles_CreateRole @ApplicationName = 'Northwind', @RoleName = 'Master'

• " ", . , , , " ", . , , ASP.NET ; , . . ASP.NET LoginView.

  , " " Login ASP.NET. , , , , , . , "" , , " " . , , ASP.NET ASP.NET . , .

• , , . :

  . .   . . web.config , .     web.config.