When installing SQL Server, you’ll need to accept all the defaults except in the following screenshots.
Choose Stand-alone installation
Don’t worry about the Windows Firewall Warning
Select All the features
Server Configuration
Use “NT AUTHORITY\NETWORK SERVICE” for all the services, and turn “SQL Server Browser” to Automatic
Database Engine Configuration
Add Current User to the SQL Server Administrators. And choose the tab “Data Directories”
In the “Data Directories” tab change these directories to the disk / subdirectories where you want your data to reside. For instance:
- g:\SAMOA\Data
- g:\SAMOA\Backup
Analysis Service Configuration
Add Current User as an Analysis Services administrator, and click on the “Data Directories” tab:
Change these directories to point to the disk where you want your data to reside. For instance:
- g:\SAMOA\AS\Data
- g:\SAMOA\AS\Log
- g:\SAMOA\AS\Temp
- g:\SAMOA\AS\Backup
Search for product updates
Make sure that at the end of the installation you search for product updates
