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.