This article assumes you have developed an ASP.NET application that uses Forms Authentication that you wish to deploy on Arvixe. The process is quite simple and you will use tools that are available from the .NET framework and the Arvixe DotNetPanel.
- Log in to your DotNetPanel.
- From the menu, select Databases → SQL Server 2008.
- Click the Create User button.
- Enter a user name and password and click Save. In this demonstration, the user name is dotnetuser and the password is dotnetuserpass.
- Click the Create Database button.
- Enter a database name and grant access to the user you created above and click Save. In this demonstration the database is called DotNetAuthentication.
- Locate and run the ASP.NET SQL Server Setup Wizard. This file is located in your .NET framework directory and is named aspnet_regsql.exe (example: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_regsql.exe).
- Click Next and choose Configure SQL Server for application services.
- Click Next and enter the server name and database log in credentials. The server name is the web site pointer address to where your application will be published and the log in credentials are the SQL server user name and password created earlier. In this demonstration, I have a web site named demoaspnetregsql and its web site pointer address is demoaspnetregsql.com.iris.arvixe.com. The database name is the one created earlier, which is DotNetAuthentication.
- Click Next twice and the wizard will take a moment to complete the scripting actions that populate the new database with all the objects necessary to configure the ASP.NET provider. Once complete, click Finish to close the wizard.
- Finally, modify the web.config file in your ASP.NET web application to use the database you created. When I deploy my application to the Arvixe host server, I change the value for the connection string to the following:
Data Source=(local)\sqlexpress;Initial Catalog=DotNetAuthentication;Integrated Security=no;User ID=dotnetuser; Password=dotnetuserpass;
That’s all there is to it! If you need information on how to configure Forms Authentication in your ASP.NET application, please review this article from Microsoft or this article from 4guysfromrolla.com.