Can I install sql server 2005 enterprise on windows server 2008 R2 64 bit.

  • Can I install sql server 2005 enterprise on windows server 2008 R2 64 bit.

    Thanks

  • Not Sure on R2 but you can install on Windows Server 2008.

    Hardware and Software Requirements for Installing SQL Server 2005

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

    List of known issues when you install SQL Server 2005 on Windows Server 2008

    http://support.microsoft.com/kb/936302

  • Yes, you can install it on Windows Server 2008 R2. But I believe you must have at least SQL Server 2005 Service Pack 3 (SP3) installed. Cheers.

  • FYI...

    Managemnt studio is not installing.

    Thanks

  • if you take a look at the MSDN link Dev provided it doesn't mention Windows2008R2 in the article, so I wouldn't install SQL2005 on Windows2008R2

    You can install on Windows2008

  • anthony.green (11/30/2011)


    if you take a look at the MSDN link Dev provided it doesn't mention Windows2008R2 in the article, so I wouldn't install SQL2005 on Windows2008R2

    You can install on Windows2008

    Actually, he can.

    In the same document, please see bottom paragraph (written by Tai Yee). I overlooked it in quick view. 😉

  • It's possible for Windows Server 2008 SP2 + SQL Server 2005 SP3 combination.

  • Doh..... missed that part

  • anthony.green (11/30/2011)


    Doh..... missed that part

    Now I believe my eyesight is quite OK.

    OR

    Both of us need to visit eye specialist. :doze:

  • Thanks all,

    Due to urgent requirement I have install sql server 2008.

    Thanks

  • Still I have not seen from my eyes to being it happen.

    I have installed the database services successfully of sql server 2005 and then Mangement studio was giving some upgrade type of error.

    Should I install SQLServer SP3 after database engine installation and then I should try to install sql server management studio?

    Thanks

  • Hi,

    First install SQL server 2005 RTM on windows server 2008 R2. Apply minimum SP3 for SQL server 2005 (now SP4 is available). Apply Microsoft visual studio SP1 (atleast) for visual studio.

    Then you can use SQL server 2005 on windows server 2008 R2. Cheers.

    Sam

  • Dev (11/30/2011)


    anthony.green (11/30/2011)


    Doh..... missed that part

    Now I believe my eyesight is quite OK.

    OR

    Both of us need to visit eye specialist. :doze:

    I believe the problem is not with the eyesight, the problem is that msdn documentation is not updated in a proper way. Many people generally miss such parts. Moreover, sometimes we do not see the document date to start with

  • pandisam66 (12/1/2011)


    Hi,

    First install SQL server 2005 RTM on windows server 2008 R2. Apply minimum SP3 for SQL server 2005 (now SP4 is available). Apply Microsoft visual studio SP1 (atleast) for visual studio.

    Then you can use SQL server 2005 on windows server 2008 R2. Cheers.

    Sam

    Yes, this is the way to go.

  • Thanks....:-)

    When I will check I will update.

    Thanks

Viewing 15 posts - 1 through 15 (of 17 total)

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