Target Servers and the Physical Model › Connecting to SQL Azure

Connecting to SQL Azure

Consider the following if your target server is SQL Azure:

• To connect to the SQL Azure database using the logins you create, you must first grant each login database-level permissions using the CREATE USER command.
• Because some tools implement tabular data stream (TDS) differently, you may need to append the SQL Azure server name to the login in the connection string using the <login>@<server> notation. In this case, separate the login and the SQL Azure server name with the at (@) symbol. For example, if your login is named login1 and the fully-qualified name of your SQL Azure server is servername.database.windows.net, the username parameter of your connection string should be: login1@servername. This restriction places limitations on the text you can choose for the login name.