How To: Qlikview 9 server with IIS Windows 2003

Posted by William on 20/11/2009 under How To | 3 Comments to Read

In some situations IIS needs to do the webserver part. With Qlikview 9, the setup for such an environment slightly changed from previous versions. This how to explains to setup Qlikview 9 with IIS on a Windows 2003 machine.

First thing to do is setting up a Windows 2003 server and install IIS. After that, make sure the machine is fully patched. Make sure you have a local account with administrative rights and can reach http://localhost

• Install ASP.NET

Go to the windows update site, choose custom and make sure the .net framework is installed and up to date.

• Make sure that ASP.NET and Active Server Pages is set to “Allowed”

Right mouse on my computer, manage and under WebService Extensions, make sure ASP.NET and Active Server Pages is set to allowed.

• Set the home directory of IIS

Go to Computer Management, Internet Information Services, Web Sites, right mouse click default website, properties and the tab Home Directory. The content for this resource should come from: ‘a directory located on this computer’.

C:\Inetpub\wwwroot

• Enable parents pad

In the same tab, select configuration, choose tab options and turn the option ‘Enable parents pad’ on.

• Install Qlikview server 9

Turn the option ‘Install typical components’ off and after that, choose to install Microsoft IIS support on local harddrive. When the installation is finished, start all (including webserver) Qlikview processes in the computer management, services screen.

• Check directory security

In IIS, default website, right click, properties (all Qlikview sites) and go to the tab directory security.

• Directory security

Choose edit and make sure anonymous is not enabled and integrated windows authentication is on.

• Modify config.xml in QvWebServer

Go to C:\Documents and Settings\All Users\Application Data\QlikTech\QvWebServer, right mouse config.xml and choose edit.

Make the following changes:

Search for:

<AccessPoint>
<Path>/QvAJAXZfc/AccessPoint.aspx</Path>

Add AP between QvAJAXZfc and AccessPoint.aspx:

<Path>/QvAJAXZfc/AP/AccessPoint.aspx</Path>

Comment out the paths under AJAX with <!– and –>
<Ajax>
<!–
<Path>/QvAJAXZfc/QvsViewClient.aspx</Path>
<Path>/QvAJAXZfc/QvsViewClient.asp</Path>
–>

Comment out all folders under Web

<Web>
<Folders>
<!–
<Folder>
<Name>QV_QLIKVIEW</Name>
<Path>C:\Program Files\QlikView\Web</Path>
</Folder>
<Folder>
<Name>QV_QVANALYZER</Name>
<Path>C:\Program Files\QlikView\QvClients\QvAnalyzer</Path>
</Folder>
<Folder>
<Name>QV_QVCLIENTS</Name>
<Path>C:\Program Files\QlikView\Server\QvClients</Path>
</Folder>
<Folder>
<Name>QV_QVPLUGIN</Name>
<Path>C:\Program Files\QlikView\Server\QvClients\QvPlugin</Path>
</Folder>
<Folder>
<Name>QV_QVJAVA</Name>
<Path>C:\Program Files\QlikView\Server\QvClients\QvJava</Path>
</Folder>
<Folder>
<Name>QV_QVAJAXZFC</Name>
<Path>C:\Program Files\QlikView\Server\QvClients\QvAjaxZfc</Path>
</Folder>
<Folder>
<Name>QV_QVPRINT</Name>
<Path>C:\ProgramData\QlikTech\Qvs\QvPrint\</Path>
</Folder>
–>
</Folders>

Save the file.

• Edit QvAccessPoint.js

Right mouse and edit QvAccessPoint.js located in C:\Program Files\QlikView\Web\ .

Search for

qva.Remote = “/QvAJAXZfc/AccessPoint.aspx”;

Change the line to match the change you did in the config.xml

qva.Remote = “/QvAJAXZfc/AP/AccessPoint.aspx”;

Save the file

• Register the qvscom remote.dll

Click Start, run, enter CMD so you get a Command prompt.
Enter the following commands:
cd\ (enter)
cd c:\program files\qlikview\server (enter)
regsvr32 QvsComRemote.dll (enter)

You will get a message the command succeeded. Qlikview web server must be started/restarted in computermanagement, services screen, this fulfills the old accesspoint functions.

• Make sure you activate your license key for Qlikview server

Enter license in the enterprise management console.

Verify that IIS is acting as webserver for Qlikview by unchecking Integrated Windows Authentication under Directory Security and visit http://localhost/qlikview. You will see that Qlikview no longer works. Doing this when using Qlikview Web Server will not have any effect.