SQL Azure: "Database 'XXXYYY' on server '' is not currently available"

Are you evaluating

an ODBC driver?

Yes I am!

There are two reasons you can get this error when using Easysoft's SQL Azure ODBC driver to connect to SQL Azure from Linux.

  • You're using Azure client redirection.

    By default, this is the case if your Linux machine is running from with the Azure cloud, that is, you have created a machine from a Linux image in Azure.

    If this is the case, please download and install version 1.10.9 or later of the SQL Azure ODBC driver. You also need to specify both the Server and ServerName attribute in your ODBC data source. For example:

    [Azure-ODBC-DSN]
    Driver=Easysoft ODBC-SQL Server SSL
    Server=myazureserver.database.windows.net
    ServerName=myazureserver
    User=myazureuser@myazureserver
    Password=myazurepassword
    Database=myazuredb
    Encrypt=Yes
    .
    .
    .
  • You're using a newly provisioned database which is not publicly available yet. There may be a delay before a newly created Azure database is accessible from the outside world.

Further information