SQL Azure Connection Help
RazorSQL can connect to SQL Azure via either JDBC or ODBC, and ships with the JDBC drivers necessary to connect to SQL Azure. Users can connect via ODBC by setting up an ODBC data source for SQL Server on their machine via the Windows data sources control panel. See below for more information on each of these connection types.
NOTE: Before connecting to SQL Azure, you may need to set up a firewall rule via the Azure control panel to give your machine's IP address access to connect to the SQL Azure database.
Connecting to SQL Azure via JDBC
To connect to SQL Azure via JDBC, open the Connections -> Add Connection Profile menu option and select SQL Azure as the database type. RazorSQL can connect to SQL Azure via two different drivers - the MS SQL Server JDBC driver and the jTDS JDBC driver. The jTDS driver is not compatible with all SQL Azure configurations. Thus, users may have more sucess using the MS SQL Server JDBC driver. This driver is listed first in the connection type list. RazorSQL can automatically download and install this driver via the button on the Add Connection Profile screen.
On Windows machines, there are 3 ways to authenticate to SQL Azure: SQL Server Authentication,
Active Directory Authentication with a user / password, and Active Directory Authentication via
single sign-on using the current users Windows credentials.
On Mac and Linux machines, the Active Directory single sign-on mechanism is not supported.
To connect via Active Directory single sign-on on a Windows machine, the Microsoft Active Directory Authentication Library must be installed on the user's machine. The library can currently be found at the following:
After selecting the authentication type and entering the login information, the host, port, and database name need to be entered to connect to SQL Azure.
Host or Ip Address: This is fully qualified name of the SQL Azure database. Typically
this may be something like xxxxxxx.database.windows.net where xxxxxxx is the specific name of your SQL Azure
Port: This is the network port on which SQL Azure listens and should be 1433.
Database Name: This is the name of the database you wish to work with. For example, master or sample, etc.
Connecting to SQL Azure via ODBC
To connect to SQL Azure via ODBC Microsoft provides the SQL Server Native client ODBC driver
For more information about setting up an ODBC data source, see the following link: