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

Connecting to SQL Azure via ODBC

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.

After entering the login information, the host, port, and database name needs 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 database.

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:

ODBC Setup