Post reply

32 bit SSRS with 64 bit SQL Server and OS

  • February 23, 2011 at 4:41 am

    #143414

    Hello,

    We have a customer with a 64 bit OS and 64 bit SQL Server. We have a web based application on this server that requires IIS to be running in 32 bit mode. The customer wants to enable SSRS, but installing the 64 bit version would require IIS to run in 64 bit mode which would cause the web bases application to fail.

    Is it possible to install the 32 bit version of SSRS (perhaps in a separate named instance), and have reports in that SSRS installation access database tables in the 64 bit default instance?

    Thank you for any assistance you could provide.

  • February 23, 2011 at 12:21 pm

    #1290570

    Please review this MSDN link, it should answer all of your questions.

    http://msdn.microsoft.com/en-us/library/ms143293(SQL.90).aspx

    Good luck

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • February 25, 2011 at 8:18 am

    #1291555

    Thanks a lot. I appreciate the reply.

  • April 27, 2012 at 7:25 am

    #1480391

    I have a similar situation but to install SQL 2008 R2 64 bit with Reporting Services 32 bit. The link is very helpful but is for SQL 2005. Are the tasks the same for SQL 2008 R2?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply