# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

# 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 (MS SQL Server) as the connection type.

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:
https://www.microsoft.com/en-us/download/details.aspx?id=48742

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 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