This is the second part of my post how to set up a SharePoint development Farm. The first part can be found here Part 1

Now that the basics are covered we can start installing the needed software. Lets begin with SQL server.

For this farm we will use SQL Server 2012.

Start the SQL Server installation. After you’ve installed the setup files you can choose which SQL features you will be needing. We don’t need to add additional features. A simple SQL server setup will be sufficient for now. If we should need additional features we can install them afterwards.

Give the Instance a name of your choosing and click next. I’ve named mine SQL because MSSQLSERVER was a little to long to remember :-).

When asked for the SQL service account it’s time to create some users in Active Directory. These are some standard users that are needed to complete this installation

Use the S_SQL account for the SQL Service accounts.

To make sure we can always connect so SQL, even if something go’s wrong we can turn on Mixed mode.

To keep a separation between our install files and our databases and logs we’ll put our data directory’s on another drive.

Now the installation can start.

After that’s done you should also create a SQL alias on your servers. Run “cliconfg.exe” and enable TCP/IP.

Then on the second tab create the alias. Choose TCP/IP, give your server alias name and the name and instance of your server.