Skip to main content

SQL Azure: Cloud Database Security

There is a division of responsibility when your SQL database is running in the cloud. Your service provider secures the physical components, facilities and network, but data security ultimately rests with you.

Editor's Note: Cloud Database Security is Similar, but Different

You’ll use some of the same methods to protect a SQL Azure cloud database installation as you do for SQL Server, but there are important differences when you move from a physical to logical environment.

TechNet Magazine: Securing SQL Azure

In this article, we look at the various features and techniques available to help you secure your SQL Azure installation, including methods of access control, authentication and encryption.

TechNet Wiki: Overview of Security in SQL Azure

SQL Azure has two types of access control: SQL Authentication and a server-side firewall that restricts access by IP address. Along with access control SQL Azure always maintains a secure connection to your database via SQL Server’s protocol encryption.

TechNet Wiki: Security Guidelines for SQL Azure

This document provides an overview of security guidelines for customers connecting to SQL Azure Database, and building secure applications on SQL Azure.

More Azure Security on TechNet Wiki:

Comparing SQL Server with SQL Azure

Similar to an instance of SQL Server on your premises, SQL Azure exposes a tabular data stream (TDS) interface for Transact-SQL-based database access. This allows your database applications to use SQL Azure in the same way that they use SQL Server. Since SQL Azure is a service, administration in SQL Azure is slightly different.

Video: How Do I Configure SQL Azure Security?

In this video, Max Adams demonstrates the creation of logins, databases and users. The views sys.sql_logins and sys.databases which allow the display of logins and databases from the master database are also discussed.

Get the Free Windows Azure Platform Trial

You can run an Extra Small Windows Azure instance with a 1GB SQL Azure database for free for the first 90 days of your trial.

Related Resources

Related Features

Windows Azure Security Essentials

Find recommended approaches to security management for applications and services hosted on the Windows Azure platform.

Refresh Your IT Skills for the Cloud

IT professionals are now being challenged to keep up with the emerging requirements for the cloud and learn the new skills needed to meet those requirements.

Build and Manage VMs in the Cloud

The Windows Azure VM role lets you run a virtual hard disk image, store that image in the cloud and load and run it on demand.