The Jet Service Tier is a group of Windows programs (operating in the background) which enable communications between Jet Reports applications (on users' computers) and the Jet Services Database (on a server).
Jet Services Database
The Jet Services Database resides on a SQL server instance and stores information about:
- Data source connection properties (i.e., which data sources are available and their connection info)
- Users (the names of Active Directory users/groups who are authorized to use Jet Reports)
- User Permissions (which users have access to which data source settings)
This provides a centralized location from where individual users can access data source settings which have been defined and assigned to those uses by the system administrator using the Jet Administration Console.
Jet Administration Console
The Jet Administration Console is a user interface which makes it easy for administrators to create and manage the information in the Jet Services Database.
See the article on Using the Jet Administration Console for more information.
Installing the Jet Service Tier
System Administrators can refer to our article on Installing the Jet Service Tier for in-depth information regarding the service tier's components, prerequisites, installation, and the process for upgrading from earlier version of Jet services.