SQL Server Performance

SQL Server in Windows 2008 64 bit and SSRS in Windows 2003 32 bit

Discussion in 'SQL Server 2008 General Developer Questions' started by sekharabcs, Nov 24, 2009.

  1. sekharabcs New Member

    Hi All,
    My question might be a silly one. However, I need some information.
    We are planning to migrate SQL Server 2005 server to SQL Server 2008 which will be installed in Windows 2008 64 bit server.
    1. Our current 2k3 server has SQL 2005, SSRS 2005. Client is planning to keep SSRS 2005 in the present server itself. So, I just wondered If we can integrate SSRS 2005 from 2k3 32 bit server to newly installed SQL 2008 on 64 bit?
    2. Can I run reports from 2k3 server connection to 2008 database which is on 2008 64 bit server?
    3. Please help me with some articles for migration of SQL 2005 to SQL 2008 too.
    Regards,
    Sekhar
  2. alent1234 New Member

    if you have spare hardware or vmware i would test. restore a copy of the RS database to a sql 2008 server and connect with a 2003 server running RS

Share This Page