My network guy is about to set up a Windows/SQL server for me and wants to know what I need. I have SQL Server 2008 R2 and am asking the best version of Windows to install (2008Rs or 2012). I will be using this server for Business Intelligence apps. We will be running SSIS packages, processing cubes and will also be using it as a Reporting Server with SSRS and more. With all this running on the server what would be the best configuration as far as hardware, versions, service packs, processors, etc...He said I can have whatever I need so Id like to run the most optimal setup. I have my SQL Server info below so if you guys/gals could point me to the best route for installing my Windows/SQL Server, Id really appreciate it.
Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Analysis Services Client Tools 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.5446
Operating System 6.1.7601