SQL Server and Vista

  • Article

If you are running Vista. Then you well definatley need SP2 available here:
https://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=D07219B2-1E23-49C8-8F0C-63FA18F26D3A

In addition if you are running SSIS packages with scripts (and most packages do), you will need a hotfix available from:
https://support.microsoft.com/default.aspx/kb/931846

If you are installing Reporting Services in Vista you will get a message about "IIS Feature Requirement". This because  the SSRS pre-requisites checks for IIS 6 and not 7. Good news is that Vista comes with some IIS6 compatiblility extras that will lett he install work. You will need to go into "Turn Windows Features On" in control panel and install following:

Web Management Tools

    • IIS 6 Management Compatibility
    • IIS 6 WMI Compatibility
    • IIS Metabase and IIS 6 configuration compatibility

  • World Wide Web Services

    • Application Development
      • .NET Extensibility
      • ASP.NET
      • ISAPI Extensions
      • ISAPI Filters
    •  Common HTTP Features
      • Default Document
      • Directory Browsing
      • HTTP Redirection
      • Static Content
    •  Security
      • Windows Authentication