Tuesday, January 5, 2010

Installing SQL Reporting Services on an existing instance

Brief Description: It can look as though reporting services is not available for install when running the sql installer on a machine with an existing SQL install but no IIS install.

Solution:

Install NET Framework and service packs for 2.x and 3.x
If IIS is not installed, do a base install (if this is external facing follow your external lock down procedures).


  • Add/Remove Programs

  • Add/Remove Windows Components

  • Choose application server

  • Leave Network COM+ access checked unless you're locking it down

  • Select ASP.NET

  • The rest of the defaults will do a basic IIS install only




  • If the server already has IIS check the .net version mapped to the default site
    Presuming your SQL server is not also a web server for exciting other exciting applications verify the default site is unused and continue to map asp.net to IIS


  • pushd c:\windows\Microsoft.NET\Framework\v2.xxx

  • If this is a new install, register 2.x to the default site with the scriptmap overwrite

  • aspnet_regiis -s /W3SVC/1/Root

  • Otherwise aspnet_regiis help has syntax for your choice of install.

  • aspnet_regiis -ir

  • run inetmgr

  • in Web Service Extensions 'ASP.NET v2.x should be installed and enabled

  • If you didn't install scriptmaps with aspnet_regiis, go the properties of the default website and choose the asp.net tab and change the version to 2.x




  • Run SQL Setup


  • You'll get a warning on edition change. Ignore this for the time being

  • Select the instance you're upgrading.

  • Install Reporting Services.
    Re-Run the current service pack install.
  • No comments:

    Post a Comment