Underlying OS SQL Server 2005 EE - W2003 R2 or W2008 SP2

  • Hey all,

    Got a question. We are deploying a new SQL Server 2005 EE environment and have to decide between W2K3 R2 or W2008 SP2. From my understanding it shouldn't matter what the underlying OS is similar to 32-bit vs. 64-bit. Is this the case?

    To complicate matters, we will be doing an new install of Sharepoint and Project Server 2007, would the OS matter then for queued jobs, etc.?

    Thanks,

    Rog

  • SharePoint and Project should be running in 2008 x64 because you can run IIS 7 in both x64 and x86 mode which gives you the flexibility to deploy code in both platforms.

    Kind regards,
    Gift Peddie

  • Than you for the reply. I think I wasn't clear. The OS for the Sharepoint and Project environment is easily decided to W2008. What I was asking is would the fact that we are going to install Sharepoint/Project impact the OS decision on the backend SQL Server 2005 platform?

    Thanks,

    Rog

  • Both applications runs Cubes which is previous projects are .sql files because Microsoft does not want developers making changes. And both are also SSRS heavy applications so you could use all the x64 memory and Win2008 is same operating system that makes your system modern.

    Kind regards,
    Gift Peddie

  • But for the most part does the underlying OS on the SQL Server make a difference on the install. I plan on going 2008 x64, but I need to confirm it will not cause an issue for the Sharepoint/Project install.

    Thanks,

    Rog

  • I don't think it will but read up on SharePoint and Project x64 SQL Server intallations to make note of all you need to prepare.

    Kind regards,
    Gift Peddie

Viewing 6 posts - 1 through 6 (of 6 total)

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