Site hosting news, tutorials, tips, How Tos and more

Almost End of Summer Updates


Here’s our App Installer updates for August:

MS SQL 2014 available now

If you’ve been anxiously awaiting SQL Server 2014 you will be happy to know that you can add an MS SQL 2014 database to your site right now in the MS SQL Manager section of Control Panel.

We continue to offer and support SQL 2008, SQL 2008 R2 and SQL 2012 as well. And as always, there is no extra charge for MS SQL databases.


Just in Time for Summer!


We just released a new round of App Installer updates:

Please note that nopCommerce 3.3 requires the ASP.NET 4.5.1 Framework in order to run properly, and that is only available on our Windows 2012 R2/IIS8 servers.  If you’re having trouble getting it to work, please open up a support ticket to have your account moved to one of those servers.

Winners of a year of free hosting announced


You’ve been asking us for the ability to auto-renew domain names, and now you can!

When we sent out the email notice of the availability of the new option we also mentioned that everyone who switched to automatic domain renewal would be eligible to win a free year of hosting.

Well we’ve chosen two winners, and they are Rodrigo Sandoval from Santiago, Chile and Bruce Roeser from Florida. Congratulations, gentlemen, and thanks for using Winhost!


Spring App Installer Updates


For those customers who just absolutely have to have the latest and greatest, here’s a list of updated applications available from the Winhost Control Panel:

More memory? More storage space? Okay, you’ve got it.


You’ve been telling us that you need more. More everything; space for your files, memory for your applications, so we put our heads together and said, “What can we do to make that happen?” The answer was simple: increase all the quotas! Now! So that’s what we did.

Okay, I’m making it sound a lot easier than it was. But over the past day or so we’ve rolled out new quotas for every Winhost plan. The changes are now in effect on all web and SQL servers.

Here are the details:

Site memory has increased to 500MB, a gain of 200MB
SQL database disk space has increased to 5GB, a gain of 2.5GB
Number of SQL databases is now unlimited
SQL database disk space has increased to 5GB, a gain of 2.5GB
Number of MySQL databases is now unlimited

Site memory has increased to 300MB, a gain of 100MB
SQL database disk space has increased to 2GB, a gain of 1GB
Number of SQL databases is now unlimited
MySQL database disk space has increased to 2GB, a gain of 1GB
Number of MySQL databases is now unlimited

SQL database disk space has increased to 500MB, a gain of 300MB
MySQL database disk space has increased to 500MB, a gain of 300MB

If you have any questions about these changes, just let us know. We want you to be able to grow at Winhost, and we hope that these quota increases help a lot of you do just that.

Go on now, get busy!

Creating ASP.NET Membership Tables in a MySQL Database


Did you know you could use a MySQL database to store your ASP.NET Membership Table information rather than Microsoft SQL Server? I’ve written this simple guide to help you get started.

First, create a MySQL database through the Winhost Control Panel. Click on the Sites tab.

WHCPSitesTabClick on the Manage link and then click on the MySQL button.

WHCPMySQLButtonClick the Add button and enter the values for Database Name, Database User, and Quota. Click the Create button to finish creating the database. Now click on the Manage link and record the connection information (Database Name, Database Server, Database User, and Database Password) on a piece of paper or a text editor such as Notepad.

Start Visual Studio and create a New Project by going to File -> New –> Project… (Ctrl+Shift+N).

NewProjectAdd the necessary .NET assemblies to your project using NuGet. Go to TOOLS -> Library Package Manager -> Manage NuGet Packages for a Solution… Type mysql in the Search field and hit Enter. Install both the MySql.Data and MySql.Web assemblies. A check mark will appear to the right when the assemblies have been installed.

NuGetAnother way to verify that the assemblies have been installed correctly is that they will appear as References in the Solution Explorer window.

ReferencesWhen you compile your project, a copy of these assemblies will be added to your local /bin folder which you will need to upload to your site account.

MySQLdllsThe next step is to modify the Web.config file with this markup:

<?xml version="1.0"?>

For more information on how to configure your ASP.NET application, please visit

    <add name="MySqlMembershipConnection"
         connectionString="Data;user id=membership;password=password;database=mysql_48503_membership;"
    <compilation debug="true" targetFramework="4.5" />
    <httpRuntime targetFramework="4.5" />
    <authentication mode="Forms">
      <forms loginUrl="~/Account/Logon"
             enableCrossAppRedirects="false" />
    <membership defaultProvider="MySqlMembershipProvider">
        <add name="MySqlMembershipProvider"
             type="MySql.Web.Security.MySQLMembershipProvider, mysql.web"
    <roleManager enabled="true" defaultProvider="MySqlRoleProvider">
        <clear />
        <add connectionStringName="MySqlMembershipConnection"
             type="MySql.Web.Security.MySQLRoleProvider, mysql.web"
        <add type="MySql.Web.Security.MySqlProfileProvider, mysql.web"

Replacing the connection string section with the Winhost Connection String to your MySQL database. Save the file. The key to creating the tables is this attribute in the XML markup: autogenerateschema=”true” Now, select BUILD -> Build Solution (Ctrl+Shift+B) to compile your application, and then select PROJECT -> ASP.NET Configuration. This will launch the ASP.NET Web Site Administration Tool.

ASPNETConfigOnce the tool has been launched, the tables will be created, and you can check by logging into your MySQL database using an administration tool like MySQL WorkBench.

MembershipTablesNow, let’s build a very simple ASP.NET application that will allow you to create users. Go back to your project in Visual Studio, right click on your project name in Solution Explorer and select Add -> New Item… (Ctrl+Shift+A). Select Web Form and name the file. Switch to Design Mode. In the Toolbox Window, expand Login of the tree view, and drag and drop the CreateUserWizard control on to the page. Build your application.

CreateUserDeploy your files to the Winhost server using FTP or Web Deploy and then access your site using a browser either with your domain name or Secondary URL. Fill out the create user form and click on the Create User button.

LoginFormIf you go back and access your database using MySQL WorkBench and query the my_aspnet_users table, you can see that the user was created.

UserCreatedYou can also just use the ASP.NET Web Site Administration Tool to create the users. Of course, none of this information is necessarily new, so I want to thank Nathan Bridgewater’s blog and Oracle for helping me put together this tutorial for our customers at Winhost.

2014 App Installer Updates


The new year brings us a round of new applications.  Note that backups and management of your MySQL databases just got easier with a one click install of phpMyAdmin: