Does InTrust Support SQL Server 64-bit?
Yes. InTrust does support SQL Server 64-bit, but this implies some limitations on deployment scenarios.
For SRS (SQL Reporting Services), IIS (Internet Information Services) can work in either 32- or 64-bit mode. Therefore, if IIS is running in 32-bit mode, this also means that SRS must be running in 32-bit mode as long as IIS, Quest Knowledge Porta and SRS are running on the same machine.
The InTrust Knowledge Portal that ships with InTrust 9.5.x requires .Net framework 1.1. This framework only ships with a 32 bit version which means that the InTrust Knowledge Portal requires IIS to run in 32 bit mode. If IIS is running in 32 bit mode and you want to run SRS on the same machine, SRS must also run in 32 bit mode. And if the SQL Server hosting SRS is on the same machine, SQL Server must be in 32 bit mode as well. This in a nutshell is the 32 bit requirement. However, if your SRS, SQL hosting SRS or SQL databases are on a different machine, then the version of SQL Server is unimportant. Finally, this requirement no longer exists with the Quest Knowledge Portal (the version that ships with InTrust 9.6) as it does not need .Net 1.1 (it uses 2.0) and as such can be run on 64 bit IIS, SRS and SQL Server. Please refer to the Quest Knowledge Portals Product Overview Guide (KnowledgePortal_1.0_ProductOverview_091107.pdf in the \Documentation\Quest Knowledge Portal\ folder of 9.5 and 9.6) explanation of the architecture for different deployment scenarios for the Quest Knowledge Portal.
Refer to Supportlink solution SOL32852 - SQL2K5 SRS on 64bit .NET 1.1 problem
Refer to Supportlink solution SOL32011 - Compliance portal and 64-bit OS
Refer to Supportlink solution SOL30680 - Support for 64-Bit Systems