Monday, February 07, 2011 11:17 PM
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.
Tuesday, February 08, 2011 4:51 AM
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
- Marked As Answer by sqlninja Tuesday, February 08, 2011 6:50 PM
Tuesday, February 08, 2011 7:16 PM
I have a quick question.. Is there any patch for SQL Server 2008 R2.
following queryresults in:
SELECT 'SQL Server ' + CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - ' + CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' (' + CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'
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...
Tuesday, February 08, 2011 8:00 PM
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/)
Wednesday, February 09, 2011 3:51 AM
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
Wednesday, February 09, 2011 11:30 AM
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!
- Proposed As Answer by Ashish Kumar Mehta Wednesday, February 09, 2011 11:30 AM