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.
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
To make sure we can always connect so SQL, even if something go’s wrong we can turn on Mixed mode.
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.