SQL 2012 and SharePoint 2010 on Windows 7 (Pt 1 of 2)

So I need a development environment. There are lots of articles on how to do this but there are also a lot of gotchas. This is my step by step guide (more for me so I can do it again).

Do your research!

I have looked at many, many articles on how to install SharePoint 2010 on Windows 7, starting with the MSDN articles stemming from Setting Up the Development Environment for SharePoint 2010 on Windows Vista, Windows 7 and Windows Server 2008. This article provides several hardware options. I have a Windows 7 Enterprise x64 machine with 6GB of RAM. Unlike most articles, I will not be using SQL 2008, instead I will use SQL 2012 RC0.

Backup

Step 1 is always to backup your machine if it has anything that you rely on. In my case this is my work laptop and I can’t afford to be without it. If you are using a VM then it is still worth making sure that you can recreate a machine with all updates installd and all pre-requisites installed so that you can spend minimal time installing if you need to repeat the process.

SQL 2012 RC0

Source Files

I have downloaded the x64 exe, CORE box and LANG box files. After executing the exe file a new folder with the installation media has been unpacked. After clicking on setup.exe a familiar ‘SQL Server Installation Centre’ is displayed. Selecting ‘Installation’ on the left produces a list on the right containing ‘New stand-alone installation’


image

Choosing this option causes a series of checks to be carried out.

Setup Support Rules

Click Next

image

Product Key

Not many choices of versions to choose from at this point in time

image

Accept the licence terms

Setup Supprt Rules


image

Setup Role

Select ‘SQL Feature Installation’ – Need to understand these aspects

image

Feature Selection

I am selecting all features except the following:

  • Replication
  • Native Reporting Services
  • Distributed Replay Controller
  • Distributed Replay Client


image

Installation Rules

More checks …

image

Instance Configuration

Going for a default instance

image

Disk Space Requirements


image

Server Configuration

Service Accounts

Leaving as default.

image

Collation

Changed collation to SharePoint default

image

Database Engine Configuration

Server Configuration

I have enabled mixed mode and added myself as an administrator

image

Data Directories

I like to know where all files are going to live – if I have to change their location in the future this makes life much easier

image

FILESTREAM

This is a DEV environment so I am enabling full access.

image

Analysis Services Configuration

Server Configuration

Selecting multidimensional and adding myself as an administrator

image

Data Directories

Again, good to know where they are incase I need to move them

image

Reporting Services Configuration

Leave as install only – SharePoint will handle the rest

image

Error Reporting


image

Installation Configuration Rules


image

Ready To Install

I always grab the bootstrap file for future installations with the same configuration, or a rebuild

image

After a while the installation is complete


image

To install SharePoint see part 2

About Al Eardley

I am an IT Professional who has spent time as a developer, a business analyst, a solution architect, a database administrator and a project manager.
This entry was posted in SharePoint 2010, SQL Server 2012 and tagged . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>