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.

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 and JDBC (jTDS Driver . . . ) as the connection type.

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