SQL Server Express and Hosting


Several questions have come up lately regarding whether SQL Server Express is an appropriate product to be used in a hosting environment.  Here are the answers:

 

·         User Instances (also known as RANU) available with SQL Server Express Edition, are NOT RECOMMENDED for hosting environments.

 

·         Shared hosting: SQL Server Express Edition is NOT RECOMMENDED for shared (multi-tenant) hosting as the scale limits and memory handling do not allow it to meet the requirements of such an environment.  SQL Server Standard Edition or Enterprise Edition are the best choice for shared hosting.

 

·         Dedicated hosting: All versions of SQL Server including Express Edition are RECOMMENDED for dedicated (single-tenant) hosting environments.  SQL Server Express Edition is a great way to provide a free copy of SQL Server with low cost Windows Server offerings.  Where customers require more advanced features or higher scale, Workgroup Edition, Standard Edition, and Enterprise Edition are all options.

 

·         Applications built on SQL Server Express Edition can be hosted in other editions of SQL Server.  There is a tool called the Database Publishing Wizard (it comes bundled with Visual Studio 2008) to help the export/import process.  If the Connection String contains a reference to User Instances, it needs to be updated (many sample applications and development tools include User Instances by default). There are several excellent post from Scott Guthrie that describe how to use the Database Publishing Wizard and how to post your ASP.NET application to a web host:

Recipe: Deploying a SQL Database to a Remote Hosting Environment

Update of SQL Server Database Publishing Toolkit for Web Hosting

Tip/Trick: How to upload a .SQL file to a Hoster and Execute it to Deploy a SQL Database

For hosters looking for more guidance on running SQL Server 2005 in a hosted environment, see the best practices article SQL Server 2005 Deployment Guidance for Web Hosting Environments.

 

Two posts in one day, I’m on a roll.

– Mike Wachal

– SQL Express team

Comments (7)

  1. SQL Server Express and Hosting As you all know, I'm all for the Express tools ( dotNetExpress ).

  2. asp to go says:

    Very interesting.  The new Windows Server 2008 – as the most substantial upgrade since 2000, has many upgrades and additions including new web, security and virtualization technologies. Our web host – Server Intellect -was the first to offer ‘Longhorn’ on all Dedicated Servers.

  3. Setting up SQL Server 2008 for an ASP.NET website on IIS 7.0

  4. Nico says:

    Quick notice that Virtual Dedicated servers will typically act the same as Dedicated servers with SQL Express 2005/2008 (been tested on Server 2003 & Server 2008 instances)

  5. download as premium says:

    It is one of the greats! It is a very helpful and useful information. Subscribe to information about me and tell me that it is only useful in any place.thank for this such information …