Error connecting to SQL Azure - “An error has occurred while establishing…”

You might get the following error when connecting to SQL Azure:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections

The reason is probably because you didn’t put the correct login name for your connection, and this can happen in Visual Studio, sqlcmd, etc.  So if you are logging in using sqlcmd for instance, it should look like so:

sqlcmd -S  svr.database.windows.net -U usrname@svr -P password -dtest –q “select 1”

Note that the entire server name needs to be used with the –S switch, but only the first part of it needs to be added to the username – usrname@svr.  I had to read this a few times before it sunk in.

Lee Everest

----------------------------------

'Cause I'm a karate man! And a karate man bruises on the inside! They don't show their weakness. But you don't know that because you're a big Barry White looking mother******! So get outta my face!