Azure SQL connection manual for DBConvert

SQL Azure connection settings

Windows SQL Azure is a cloud-based relational database service developed on SQL Server technologies. Thus, your database application can use Azure SQL similar to the way it uses SQL Server.

First of all, you should create an account at https://www.windowsazure.com/

Let’s check connection. Here we use trusted connection.

Connect to SQL Azure using SSL and via port 1433.
Note: SQL Azure supports only SQL Server Authentication using a login and password.

In SQL Azure every table is supposed to have a clustered index. Though it’s possible in SQL Azure to create tables without clustered indexes but when trying to add rows to a table the following error occurs:

Note: Heap tables are not allowed in SQL Azure because this sort of tables doesn’t have any clustered indexes by definition.