SQL Server and Vista
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
- Application Development