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: