SharePoint 2013 Best Practices: Creating a Dev Environment: Installing SQL Server

  • Article

Go back to Creating a Dev Environment

Install SQL Server 2012 with SP1
At the time of writing, this is the latest version of SQL Server.

  1. Choose New SQL Server stand-alone installation and follow instructions.
  2. Select All Features with Defaults.
  3. Note: At this point, you can't install the SSRS add-in for SharePoint yet. You'll need to do that after SharePoint is installed.
  4. Since it's the first installation, it's fine to choose Default instance.
  5. Provide a valid account name for SQL Server Analysis Services. We've made sure that at this point, the admin account and password never needs to be changed anymore, so we're using this account. For a development machine, acceptable, we think.
  6. When you're asked to choose an authentication mode, choose Mixed Mode. This account, at this point, needs to have a complex password.
  7. In the Analysis Services Configuration dialog window, Add Current User.
  8. In the Reporting Services Configuration dialog window, choose Install Only for both options.
  9. Add Current User in the Distributed Replay Controller dialog window and make your server name [moon, in our case] the controller.

 

See Also