Frequently Asked Questions IQSweb

Categories of FAQs

FAQs - Installation

Q: I have installed IQSweb on a Windows 7 machine.  No images appear and the pages are not formatted properly. (Ticket 75)

A: If installing under Windows 7, check to make sure the following feature in IIS is turned on.   Under Turn windows features on or off> Internet Information Services > World Wide Web Services> You need to Check Static Content.

Q: I am unable to connect to the database during the IQSweb Web Service Installation even though I have remote connection set to allowed. (Ticket 13)

A:

  1. Open SQL Server Management Studio.
  2. Right-click on the server in the Object Explorer on the left and select Properties.
  3. In the new window, select "Permissions" on the left-hand side.
  4. In the "Logins or Roles" box, find and select the IQSUser created for the IQS database.
  5. In the bottom Permissions box, in the "Explicit" tab, make sure that the user has the Grant checkbox selected for "Connect SQL".
  6. Click OK.

Q: I am installing IQSweb on Windows 2003.  I received "Page Not Found (404) Error" when trying to view Web Service page after installing web service. (Ticket 12)

A: Open IIS Manager:

  1. Go to the Control Panel
  2. Open Administrative Tools.
  3. Open Internet Information Services.
  4. In the window, expand the computer name.
  5. Click Web Service Extensions.
  6. In the right-side of the window, select "ASP.NET v2.0.50727"
  7. Click the "Allow" button.
  8. Restart IIS by clicking the stop icon in the toolbar (the black square) and then the start button (the black triangle).

Q: When installing IQSweb Web Service, I get the following error "Installation was Incomplete  The Installer was interrupted…press close and reinstall" (Ticket 11)

A: There was an error immediately when the files were being copied over. This is caused by IIS not recognizing the ASP.NET framework. To resolve this error, run the following command from the windows command prompt.

  1. Open the command prompt (Start->Run->Type "cmd" (without quotes))
  2. To get in the correct .NET Framework directory: cd "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727"
  3. To re-register .NET in IIS: aspnet_regiis.exe -i
Top of Page

FAQs - Configuration

Q:

A:

Q:

A:

Top of Page

FAQs - Updates

Q: Steps to Upgrade from SQL Server 2005 to SQL Server 2008 (Ticket 89)

A: If you are upgrading and moving to a new server, follow the steps below:

  1. Make a .BAK of 2005 IQSweb database.
  2. Install/Upgrade to 2008 SQL Server.
  3. Restore the 2005 database into the new 2008 SQL server making sure the database login that IQSweb was using is set to the same username, password, and permissions (db_owner is the permission defined in the IQSweb installation instructions) as in the 2005 database.
  4. Edit web.config file located where web service is installed (i.e. c:\inetpub\wwwroot\iqsws\web.config). Look for a section called CONNECTIONSTRINGS. Edit the item IQSWebDBConnection to make sure the connection string attribute matches the new location of the database.

Q:

A:

Top of Page

FAQs - ROSS

Q: When I try to Send Updates in ROSS Management, the gray pop-up box appears (showing the updates ready to send, status and elapsed time), but then nothing happens.  The box does not go away, appears to freeze on the screen and nothing is processed.

A: Go to ROSS NAP and change your ROSS password.  Send your updates again after changing your ROSS password.

Q:

A:

Top of Page

FAQs - Reports

Q: Error when trying to export report to Excel. (Ticket 88)

A: Export to Excel problems for reports with complicated formatting, pick the Export to Excel (Data Only) option.

Q: Why can't I see the icons on the reports toolbar? (Ticket 3)

A: The folder where crystal reports icons is not accessible to IQSweb.

  1. Open Internet Information Services and look for the "aspnet_client" folder.
  2. If you cannot view the folder, look on the web server for the folder aspnet_client.  It is usually installed at the root level of the we server's base directory (for example, c:\inetpub\wwwroot)
  3. Create a virtual directory called "aspnet_client" that points to the location of the actual "aspnet_client" folder.

Q:

A:

Q: I am using a 64-bit computer.  When I try to run reports, I get the following error "Error occurred while attempting to load Crystal Reports runtime". (Ticket 17)

A: For a 64-bit installation, use the regular IQS installers, but use the 64-bit Crystal Reports installer that is available for download in the downloads section.

Top of Page