This post outline the basic steps for how to install SQL Server 2014 on Win2008R2.
- SQL Server 2014 RTM
- Cumulate Update 3: SQL Server 2014 build versions http://support2.microsoft.com/kb/2936603
- Sample Database: http://msftdbprodsamples.codeplex.com/Releases/
I am going to manually apply the CTP later, hence I will not check the “use Microsoft update to check for updates”
I always prefer the Named instance.
Change the installation directory
Change the port number
Upgrade to CU3
At the time I write this post, the latest cumulative update is CU3.
Install Sample Database
The adventure Works 2014 is just the database backup. therefore we can easily to restore it with restore database statement.
Because I have change the default database directory for the sql server, therefore I need to use RESTORE FILELISTONLY to find the logical file name first and use WITH MOVE in the RESTORE DATABASE command.
Install Northwind sample database
The backup file can be download from http://northwinddatabase.codeplex.com/