Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Setting up an Azure SQL data source in Jet Professional


Overview

Setting up an Azure SQL Data Source using Jet Professional

Before you can create a Data Source connection, you must first download and install Jet Professional from the Jet Professional download site.


You’ll also need the following files and information:

 

  • For Jet Professional or Jet Essentials 2013 and higher: your Jet License Activation Code
  • For Jet Essentials 2012 R2 and earlier: your Jet License Files (.jlf)
  • Database Information:
    • Azure Server Name
    • Database user name and password

 

Step-by-Step

To create a new Universal data source connection to your Azure SQL database, start by clicking the Data Source Settings button on the Jet ribbon.

 

On the Data Source Settings window, click the "Add" button.

 

On the New Data Source window, provide a name for your Azure SQL data source and select "Universal" for the type.  Click OK .


On the Data Source Settings window, click the Configure... button.

 

On the Provider tab of the Data Link Properties window, you may find several SQL Server providers...

Azure SQL uses a special version of SQL Server with the best match currently being "SQL Server Native Client 11.0" (using an earlier provider may result in decreased capabilities).

Some database products include their own, specific database driver.  You'll want to check with the software provider of your database to determine the correct driver to use.

If "SQL Server Native Client 11.0" does not appear in your list, you will need to obtain a copy from Microsoft and install it.

At the time of this writing, these links were provided by Microsoft for this purpose:

SQL Server 2012 Native Client
32-bit Package: http://go.microsoft.com/fwlink/?LinkID=239647&clcid=0x409
64-bit Package: http://go.microsoft.com/fwlink/?LinkID=239648&clcid=0x409

(be sure to select the package that matches the bit-level of your version of Windows)


Depending upon which driver you choose, the appearance of the Connection tab can vary.

On the Connection tab, specify:

  • The name of the Azure server using the format: azure_server_name.database.windows.net
  • The logon information: the user name (in the format: user_name@azure_server_name ) and password (be sure to check the Allow saving password box)

 

You can then click the Test Connection button to verify your settings.  You should receive a confirmation message:

 

Some database providers do not (by default) save the password even when the Allow Saving Password box is checked.

If you experience this issue, go to the All tab and ensure that Persist Security Info is set to True:

 

Once you have successfully tested your connection from the Data Link Properties , Click OK and the Data Source Settings window should show that you are licensed for the data source.

{If the text reads that " You are not licensed for this data source ", click that text to get additional information about the issue.}

You can then click the Test Connection button and should see the Test Connection Succeeded message.

Click OK .

If you would like this data source to be the default data source that Jet Professional will use, click the Set Default button on the Data Source Settings window.

Click OK and y our Azure SQL data source is now ready for use with Jet Professional.

 
 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments