There are particular cases in which an organization will want users not currently on the same network as the SQL Services Analysis Services database to be able to connect to their Jet Analytics cubes. Some examples of this include remote employees or employees in satellite offices that are not constantly attached to the corporate network. Enabling a VPN connection will typically resolve this but in some cases this is not desirable.
In these cases, Microsoft Internet Information Services can be configured to provide access to SQL Server Analysis Services.
IIS must reside on the same server as SQL Server Analysis Services and the Jet Analytics OLAP database.
Once a secure connection has been enabled between IIS and the OLAP database , Jet Reports can be configured to utilize that connection.
First, you will need to create a Jet Reports Cube data source:
Once the General tab is displayed...
Move to the Connection tab...
Enter in the Fully Qualified Domain Name as was specified when the secure connection was created in IIS. Be sure to include the HTTPS prefix to identify this server name as a valid Internet URL.
If you are a Jet Reports user, you may need to get this information from your system administrator.
For now, leave the Database field blank
Next, move to the Authentication tab...
Select Windows authentication (Other user) and then provide the full domain name and the credentials that have been established for you on that domain (again, you may need to get this information from your system administrator).
Please note that the HTTPS prefix is *not* used here.
Next, return to the Connection tab...
Use the pulldown arrow in the Database field and select the OLAP database which contains your Jet Analytics Cubes.
Once you click the OK button, your data source should now be ready for use by Jet Reports.