This article describes the installation process for a SQL server on an all-in-one SharePoint 2010 development server.

If you didn’t follow Part 1 of the SharePoint 2010 Installation series you’ll need to create a SQL service account to support the SQL Server 2008.  While there are many ways to configure SQL and many possible features that you can activate, the steps below demonstrate a “least” features approach allowing you to simply install and run a dumb SQL Server.

Let’s start by mounting the SQL Server ISO to a virtual host.  Once mounted the operating system will ask you if you’d like to run Setup.exe.  If you do not have a SQL ISO I recommend downloading the latest version from Microsoft here: http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx .  The version I install below is SQL Server 2008 Standard.

Run setup when the virtual drive auto-plays

Under installation choose "New SQL Server stand-alone installation…"

If you followed my installation steps in Part 1 your setup support rules should all pass

For a development server you can safely ignore the messages below

Do not install Reporting Services if you plan on configuration SSRS in an integrated SharePoint mode

Use the service accounts create in Part 1 of this series

Add the uses who you would like to have administrative rights to the SQL Server

Take a snapshot

Install any SQL Service Packs (Currently SP1)

Configure a SQL Server Alias for SharePoint, this allows you to re-home your SharePoint client to use a different SQL Server (possibly a different instance) when necessary. 

(Note that I have a more detailed article about how to create a SQL Alias on a server with no SQL Client tools installed)

Enable TIP/IP

Under the 32 bit Client 10.0 Configuration (32 Bit)

** yes, one would think you need to do it under the 64 bit but SQL Server Management Studio thunks to 32 bit

Repeat the steps above for SQL Native Client 10.0 Configuration

** SharePoint uses the 64 Bit Native Client

Test your connection using enterprise manager

Note that the above version 10.0.2531 is not supported by SharePoint, we will need to install a hotfix (only available by request) from Microsoft.

Search the internet for KB970315 and download the necessary binaries

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

In the next part of this series we will install and configure SharePoint on our server.

Popularity: 17% [?]