The client PCs being used to access Practice IQ usually need additional files installed, to ensure they will connect to the SQL Server, and correctly display information. There are also some settings that need to be applied to Internet Explorer on the workstations that will be using PIQ.
Internet Explorer Settings
Open Internet Explorer, select Tools -> Internet Options from the main menu.
Click on the Security tab.
Select Trusted Sites and click on the Sites button.
Add the web server address as a trusted site, i.e. http://<servername>.
Remember to remove the tick to enable http (rather than https) when adding the trusted site.
This will take you back to the Security Tab.
From here click on the Custom Level button
Ensure ALL Active X settings are set to Enable.
Exception:“Only allow approved domains to use ActiveX without prompt" setting should be marked as Disable.
Ensure the following settings are also set as shown.
Install Additional Drivers
The next step is to ensure that you have the correct connectivity components installed on the workstation.
They are located in PracticeIQ install disk in the Utilities folder or can be downloaded from below links.
1. OWC11.exe (Office Web Components 2003) - OWC11.zip
2. The specific OLAP driver for the architecture of the workstation and the version of SQL Server they are running. There are 2 different architectures (32 & 64 bit) and 3 different versions (2005, 2008, 2012 & 2014). There are 8 components available. Please download and install the right component for your machine - see the list below:
e.g. Download OLAP2012Drivers if PIQ is on SQL 2012 version. Each download contains 2 files, x86 is for 32 bit Windows and the x64 for 64 bit Windows. Check user's machine if it is on 32 bit of 64 bit Windows and install the correct file.
Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider is required for connection to SQL 2005 Analysis Services Database's - here are the link:
Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider is required for connection to SQL 2008 Analysis Services Database's - here are the link:
Microsoft SQL Server 2008 r2 Analysis Services 10 OLE DB Provider is required for connection to SQL Server Analysis Services Database's - Here is the link:
Microsoft SQL Server 2008SP3 Analysis Services 10 OLE DB Provider is required for connection to SQL Server Analysis Services Database's - Here is the link:
Microsoft SQL Server 2012 Analysis Services 11.0 OLE DB Provider is required for connection to SQL 2012 Analysis Services Database's - here are the link:
Microsoft SQL Server 2014 Analysis Services 12.0 O LE DB Provider is required for connection to SQL 2014 Analysis Services Database's - here is the link to the feature pack download. Click on download and select the 64bit or 32bit depending on what is relevant for the PC you are installing it on.
On completion, your 'Program and Features' should have the entry. For example: