If you select Business Intelligence Development Studio (BIDS) to be installed when you install Microsoft SQL Server 2005 Service Pack 3 (SP3) on Windows Vista or Windows Server 2008, you may receive the following Program Compatibility Assistant message:
This Program has known compatibility issues Check Online to see if solutions are available from the Microsoft website. If solutions are found, Windows will automatically display a website that lists steps you can take. Program: Visual Studio 2005 Publisher: Microsoft Visual Studio 2005 has a known compatibility issue with this version of Windows.
Note You may also receive this error message when you try to upgrade to SQL Server 2005 SP3, and BIDS is already installed.
This issue occurs because the Visual Studio component that is included in SQL Server 2005 SP3 has a known compatibility issue with Windows Vista and Windows Server 2008.
To resolve this issue, follow these steps:
After you install SQL Server 2005 SP3, install Microsoft Visual Studio 2005 SP1. To do this, visit the following Microsoft Web site:
Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Workgroup Edition, Microsoft SQL Server 2005 Express Edition with Advanced Services