none
Upgrade SQL Server 2005 32bit to 2008 64bit while keep Report Services (SSRS) running

    Question

  • A server of my company is running SQL server 2005 with 32bit. Now we would like to upgrade it to SQL server 2008 with 64 bit. But the Report Services (SSRS) is running on that server and must run all the time. What should we do to upgrade while keeping the SSRS running? Or it we have to shut down the SSRS, how long will be the down time?

    Appreciate it.
    Tuesday, March 7, 2017 12:20 AM

Answers

  • Hi,

    I think upgrading 32 bit SQL Server to 64 bit(in place upgrade) is not supported by MSFT

    SQL 2008 is out of mainstream support. You should consider upgrading to SQL2014

    Why not do a side by side install/migration? See more information in this link for your scenario

    https://blogs.msdn.microsoft.com/cindygross/2009/07/07/x64-windows-upgrade-from-32bit-sql-server-to-64bit-sql-server/

    Regards,

    Bhanu

    • Proposed as answer by Olaf HelperMVP Tuesday, March 7, 2017 4:43 AM
    • Marked as answer by yxzhou624 Tuesday, March 7, 2017 10:00 PM
    Tuesday, March 7, 2017 1:12 AM
  • It can't be done as you can't upgade 32 bit to 64 bit. Also SSRS uses 2 databases (ReportServer, and ReportServertempdb) which will go offline during the upgrade.
    • Marked as answer by yxzhou624 Tuesday, March 7, 2017 9:59 PM
    Tuesday, March 7, 2017 1:42 AM

All replies

  • A server of my company is running SQL server 2005 with 32bit. Now we would like to upgrade it to SQL server 2008 with 64 bit. But the SSRS is running on that server and must run all the time. What should we do to upgrade while keeping the SSRS running? Or it we have to shut down the SSRS, how long will be the down time?

    Appreciate it.
    Tuesday, March 7, 2017 12:10 AM
  • Hi,

    I think upgrading 32 bit SQL Server to 64 bit(in place upgrade) is not supported by MSFT

    SQL 2008 is out of mainstream support. You should consider upgrading to SQL2014

    Why not do a side by side install/migration? See more information in this link for your scenario

    https://blogs.msdn.microsoft.com/cindygross/2009/07/07/x64-windows-upgrade-from-32bit-sql-server-to-64bit-sql-server/

    Regards,

    Bhanu

    • Proposed as answer by Olaf HelperMVP Tuesday, March 7, 2017 4:43 AM
    • Marked as answer by yxzhou624 Tuesday, March 7, 2017 10:00 PM
    Tuesday, March 7, 2017 1:12 AM
  • It can't be done as SSRS uses 2 databases (reportserver, and reportservertempdb) on the SQL Server. As Bhanu points out you also can't upgrade the architectures - you can't upgrade a 32 bit server to a 64 bit server.
    Tuesday, March 7, 2017 1:41 AM
  • It can't be done as you can't upgade 32 bit to 64 bit. Also SSRS uses 2 databases (ReportServer, and ReportServertempdb) which will go offline during the upgrade.
    • Marked as answer by yxzhou624 Tuesday, March 7, 2017 9:59 PM
    Tuesday, March 7, 2017 1:42 AM
  • As the others already wrote, Cross-platform (32 <=> 64 bit) upgrade is not supported, see Version and Edition Upgrades => "You cannot upgrade a 32-bit instance of SQL Server to native 64-bit"

    You have to do a side-by-side migration instead.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, March 7, 2017 4:43 AM