Thursday, March 11, 2010

Installing a SQL Server 2008 named instance – Windows Server 2008 R2

Run the setup from your SQL Server 2008 CD

clip_image002

clip_image004

Click Installation tab and click New SQL Server Stand Alone installation or add features to an existing installation.

clip_image006

clip_image008

clip_image010

clip_image012

clip_image014

clip_image016

Accept the licensing terms.

clip_image020

clip_image022

Give a name to the SQL Server instance.

clip_image024

clip_image026

clip_image028

i am not going to install this particular instance in mixed mode hence i have selected the windows authentication mode. Setup wont allow you to go to next step unless if you didn't specify a administrator account. I have added the current user credential as one of the administrator account for the SQL Server.

clip_image032

clip_image036

clip_image038

clip_image040

clip_image042

clip_image044

clip_image046

clip_image048

clip_image050

http://support.microsoft.com/kb/955499

http://support.microsoft.com/kb/956173

0 comments: