Product Documentation

Microsoft SQL Server Hosting

Jun 05, 2015
Updated: 2014-01-20

The Microsoft SQL Server Hosting service for Services Manager enables you to host instances of Microsoft SQL Server from the cloud.

The service requires no web service to be installed and uses a remote connection to Microsoft SQL Server in your environment.

Multiple SQL Server databases can be provisioned to a customer and the customer can then assign users to the databases. The customer's databases can be provisioned to different SQL Servers or instances, depending on the resource configuration.

Supported versions

The Microsoft SQL Server Hosting service supports the following versions of SQL Server:
  • Microsoft SQL Server 2005
  • Microsoft SQL Server 2008
  • Microsoft SQL Server 2008 R2
  • Microsoft SQL Server 2012

Requirements

When preparing SQL Server for your Services Manager deployment, perform the following tasks:
  • Ensure the SQL Server is a member of a domain managed by Services Manager.
  • Set the Authentication mode to SQL Server and Windows Authentication.
  • Enable remote connections to the server.
  • Enable protocols for remote connection, such as TCP/IP.
  • Open inbound firewall ports required for the SQL Server instance and for Services Manager. The port for default instances of SQL Server is TCP 1433. The default port for Services Manager is TCP 8095.
  • Ensure the SQL Server Browser service is running and set to start automatically. This ensures Services Manager can locate the SQL Server and enumerate the instances installed when you configure the Microsoft SQL Server Hosting service in the control panel. If you are using named instances of SQL Server, ensure UDP port 1434 is also open for inbound connections.
  • Install the SQL Native Client component on the Services Manager Provisioning server. The 32- and 64-bit clients for each supported version of Microsoft SQL Server are available from the Microsoft downloads site.

Service deployment overview

Deploying the Microsoft SQL Server Hosting service involves the following tasks:
  1. Ensure the SQL Native Client component is installed on the Services Manager Provisioning server.
  2. Configure the service using the control panel. This includes creating a server collection and retrieving SQL Server instances from each SQL Server in the collection.
  3. Provision the service to customers.

For deployment instructions, see Deploy the Microsoft SQL Server Hosting service.