SQL server 2008 R2 on windows server 2008 R2

Question

I am trying to install SQL server 2008 R2 on windows Server 2008 R2. both 64 bit.

At installation rules window, 64 bit processor and 64 bit operating system -- both have  not applicable status. I am not sure what does this means? Are these two Rules for some other setup, I thought SQL server setup will automatically pick up 64 bit edition.

Please advise,

Thanks!

Answer 1

Please ignore it  ...you can install sql server 2008 R2 on windows server 2008 r2 64 Bit .
 and as you said sql server setup will automatically pickup the 64 bit edition .

Please read the following whitepaper : Microsoft SQL Server 2008 R2: The Best Data Platform on Windows Server 2008 R2 White Paper

----------------------
Thanks,Suhas V

Answer 2

I have a quick question.. Is there any patch for SQL Server 2008 R2. 

following query

SELECT 'SQL Server ' 
+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - ' 
+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' (' 
+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'

results in:

SQL Server 10.50.1600.1 - RTM (Enterprise Edition (64-bit))

I think this is latest and there is no upgrade or patch releases so far.. but I am not sure. Is there any resource where I go to find this information...

thanks!

Answer 3

I came across a site which has listed all updates : http://sqlserverbuilds.blogspot.com/

From the website, it appears I should update it from 10.50.1600.1 to 10.50.1753 ( http://support.microsoft.com/kb/2438347/)

Answer 4

It is not recommended to install this hot fix as mandatory. Apply only if you are facing any issues mentioned in the KB . Please read the below

A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server 2008 R2 service packs that contains the hot fixes in this cumulative update package

------------------------------
Thanks,Suhas V

Answer 5

Hello,

Read Installing SQL Server 2008 R2 on Windows Server 2008 R2 article which describes the steps to install a standalone instance of SQL Server 2008 R2 on Windows Server 2008 R2.

Hope that Helps!

 

Thanks
Ashish Kumar Mehta

 

Please click the Mark as Answer button if a post solves your problem!