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)
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
Ulysses Ludwig is a SharePoint architect with over 16 years in the IT and computer industry. Ulysses' primary focus is SharePoint but he dabbles in the latest web technologies and likes to develop software in his spare time.
Security Exception Uninstalling or Configuring WSS displays an error message in application event log stating "Failed to unprovision the SharePoint Central Administration Web Application".
4 Comments for SharePoint 2010 Installation Part 2 – Install SQL