SQL Report server and Symantec Enterprise Vault

First I'll tell you that I think SQL reporting services is like a last minute, hobbeled together fluffy add-in compared to the rest of SQL. This applies whether were talking about 2000 or 2005. Maybe Microsoft will do better with 2008?

Anyway I threw this article together as kind of a guide after many installs of SQL reporting services in conjunction with Symantec Enterprise Vault.

There is a definitive guide located at http://msdn.microsoft.com/en-us/library/ms143736.aspx. This will help you with a lot of your selections and understanding Reporting Services bettter.

Determine what version you need to install, x86 or 64bit. You may have a SQL 64 bit install but need to install 32 bit reporting services as this is common. Many vendor related software packages that rely on SQL reporting only run in 32bit (x86). If that's the case then there are some pre-requisites to making that work.

Listed in great detail here http://msdn.microsoft.com/en-us/library/ms143293(SQL.90).aspx is a guide to Install 32-bit Reporting Services on a 64-bit Computer

Here are the basics from this guide:

To install 32-bit Reporting Services on 64-bit IIS 6.0

1. If necessary, uninstall the 64-bit version of Reporting Services. Side-by-side deployment of 64-bit and 32-bit versions is not supported.
2. Run dotnetfx64.exe to install the Microsoft .NET Framework manually. You can find this file in the Redist folder on the SQL Server 2005 Setup media, or you can download it from Microsoft .NET Framework Version 2.0 Redistributable Package (x64) on the Microsoft download site.
3. In IIS Manager, click the Web Server Extensions folder.
4. In the Details pane, right-click ASP.NET V2.0.50727, and then click Allowed.
5. Right-click the Web Sites folder and then select Properties.
6. Click ISAPI Filters.
7. In Filter Name, select ASP.NET_2.0.50727, and then click Edit.
8. Replace "C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\aspnet_filter.dll" with the 32-bit version that is located in the Framework folder: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll.
9. Click OK. Save your changes, and close IIS Manager.
10. Open a command prompt window, and then run the following command:
    1. cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1
11. Install the 32-bit version of Reporting Services.
12. After Setup is complete, open IIS Manager, click the Web Server Extensions folder.
13. In the Details pane, right-click ASP.NET V2.0.50727 (32-bit), and then click Allowed.

 

TrackBack URI for this entry