Troubleshooting a failed Reporting Server installation

Article:TECH101794  |  Created: 2006-01-05  |  Updated: 2009-01-24  |  Article URL http://www.symantec.com/docs/TECH101794
Article Type
Technical Solution


Environment

Issue



You install Microsoft Internet Information Services (IIS) and Reporting Server. When you go to the Reporting site in Symantec System Center, you see an error message.


Solution



There are a number of reasons that this problem can happen. Follow these troubleshooting steps to identify the problem.

Check possible installation problems
  • If any components were installed through a Terminal session, uninstall all Reporting components and install them locally.
  • If you have used the IIS lockdown tool, you must use the lockdown tool again to undo the changes that it made. If you need assistance with the tool, contact Microsoft.


Ensure that required components are running
Reporting requires IIS, PHP, and either MSDE or Microsoft SQL Server in order to function. Follow these steps to make sure that each of those components is installed and running.

To verify that IIS is running
  1. Start Microsoft Internet Explorer.
  2. In the address bar, type the following and press Enter:

    http://localhost
  3. You should see the IIS administration page (http://localhost/localstart.asp).
    If you do not see the page, IIS is not installed correctly. The following Microsoft article may help in this situation: Q271071 – "How to set required NTFS permissions and user rights for an IIS 5.0 Web server"
    If the page still does not appear correctly, contact Microsoft IIS support for assistance.
 
To verify that PHP is installed and running
  1. Check that the following file exists: C:\Program Files\Symantec\Reporting Server\Php\php.exe
    If the file does not exist, PHP is not installed correctly.
  2. Go to the folder C:\Program Files\Symantec\Reporting Server\Php\.
  3. Create a file called test.php. Open the file with Notepad, and add the following text:


  4. Click Start > Run, and type cmd.
  5. Type the following and press Enter:

    cd "c:\program files\symantec\reporting server\php"

  6. Type the following and press Enter:

    php.exe test.php > test.php.txt


    This command creates a text file called test.php.txt.
  7. If test.php.txt does not exist, PHP is not installed correctly.
  8. Open test.php.txt in a text editor and examine the first line.
    If the first line does not start with "phpinfo() PHP Version =>" then PHP is not installed correctly.

To verify that Microsoft SQL Database is running
Check the Windows notification area for a SQL Server Service Manager icon. If the icon is there and displays a green triangle, then the SQL Server is running. If the icon is not there, or if it is red, then look in Services to make sure that the service MSSQLSERVER exists and is started. If MSSQLSERVER does not exist or cannot start, then Microsoft SQL is not installed correctly.


Ensure that the Reporting components work together
Follow these steps to test whether the components of Reporting are working together correctly.

To verify that PHP works through IIS
  1. Create the following folder: C:\Inetpub\wwwroot\Test.
  2. Move the test.php file that you created in step 3 into C:\Inetpub\wwwroot\Test.
  3. Start IIS.
  4. In IIS, right-click the default site and click New > Virtual Directory.
  5. In the IIS Virtual Directory Creation Wizard, click Next.
  6. Under Alias, type Test, then click Next.
  7. Under Directory, type the following, then click Next:

    C:\Inetpub\wwwroot\Test\

  8. In the Access Permissions list, check Execute, and then click Next > Finish.
  9. In the Default web site, right-click Test, and click Properties.
  10. On the Virtual Directory tab, under Application settings, click Configuration.
  11. On the App Mappings tab, under Application mappings, click Add.
  12. Click Browse.
  13. Select C:\Program Files\Symantec\Reporting Server\Php\Php-cgi.exe.
  14. In the Extension field, type .php.
  15. Click OK.
  16. Start Internet Explorer, and go to http://localhost/test/test.php.
  17. If a page with detailed info on the PHP version does not appear, IIS is not configured correctly.
 
To verify that Reporting Server is tied to IIS
  1. In IIS, look for a virtual directory named Reporting.
    If Reporting does not exist, follow the steps in "To create the Reporting virtual directory if it does not exist".
  2. On the Documents tab, add Index.php and move it to the top of the list.
  3. Close IIS Manager.
  4. On the Windows taskbar, click Start > Run, type iisreset, and click OK.
  5. After the services start again, start Internet Explorer and go to http://localhost/reporting.
  6. Log on to the site with the user name and password that you created when you installed Reporting.

To create the Reporting virtual directory if it does not exist
  1. In the IIS Manager, in the Default Web site, create a virtual directory called Reporting.
  2. In IIS, right-click the default site and click New > Virtual Directory.
  3. In the IIS Virtual Directory Creation Wizard, click Next.
  4. Under Alias, type Reporting, then click Next.
  5. Under Directory, type the following, then click Next:

    C:\Program Files\Symantec\Reporting Server\Web\

  6. In the Access Permissions list, check Execute, and then click Next > Finish.
  7. In the Default web site, right-click Test, and click Properties.
  8. On the Virtual Directory tab, under Application settings, click Configuration.
  9. On the App Mappings tab, under Application mappings, click Add.
  10. Click Browse.
  11. Select C:\Program Files\Symantec\Reporting Server\Php\Php-cgi.exe.
  12. In the Extension field, type .php.
  13. Click OK.







Legacy ID



2006040513034348


Article URL http://www.symantec.com/docs/TECH101794


Terms of use for this information are found in Legal Notices