Provisioning SQL 2005 Resources

by Walter Oliver

Overview

SQL Server® 2005 is an ideal database platform for use in shared and dedicated Web hosting environments.

Deployment Guide

The SQL Server 2005 Deployment Guidance for Web Hosting Environments provides best practices for configuring SQL Server 2005 to optimize security, tenant isolation, and the performance of your hosted SQL Server 2005 deployment. Sample scripts for provisioning users and databases for use in shared hosting are included.

User Provisioning

The User Provisioning section covers:

  • User and database provisioning (logins, users, and databases)
  • Stored procedure for creating assemblies