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

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

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 its 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 dev 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

Leave a Comment
  • Please add 1 and 4 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
Page 1 of 1 (2 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
Page 1 of 1 (2 items)