Installing 64bit SQL2008 On Windows 2008 R2

Posted by Kasi Krishnamoorthy at 11/23/2009 03:13:00 PM

 

My system Configuration: Intel Xeon Processor 64 bit with Windows 2008 R2.

When I try to install SQL server 2008, the following error message was displayed.

image

Then I realized that, only SQL Server 2008 SP1 can be installed on Windows 2008 R2.

Download SQL Server 2008 SP1, and follow the method mentioned in this article to slipstream SQL Server 2008 SP1

Note: If you want to use the SQL server 2008 with SharePoint 2010, you also need CU2 for Sp1 which can be found here (http://support.microsoft.com/kb/970315)

Select “Run Program” and rest of the screen shots are self explanatory.

image

select installations and then select SQL server Standalone edition.

image

 

Enter Product Key and Accept License Agreement.

Then install setup support files…

image

image 

Fix any issues..

image

Select the required components from the next screen.

image

Select the location for SQL server files

image

Select an account name for each service. you can also use the button at the bottom of the screen to assign one account for all the services. It is easy some time to use local system account.

image

Select the authentication method and assign at least one administrator to the server.

image

On the FILESTREAM tab of the Database Engine Configuration page, select the
options for Enable FILESTREAM for Transact-SQL access and Enable FILESTREAM
for file I/O streaming access. FILESTREAM can also be enabled later, if you don’t know whether this option is required or not.

 

On the Analysis Services Configuration page, specify an administrator as an
Analysis Services administrator by clicking the Add Current User button at the bottom
of the page

image

 

Select the Install the native mode default configuration on reporting services configuration section. The report server will be usable after the configuration.

image

image

Now you are ready to install and make sure the slipstream is defined properly as shown below.

image

If everything goes well, you should see success screen as shown below.

image

0 comments: