Hi manaqfx,
You are getting the following erro while attaching the Northwind file.
Database 'Northwind' cannot be upgraded because its non-release version (539) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database.
Could not open new database 'Northwind'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 950)
The Database version 539 stands for SQL Server 2000.
This is no longer supported in higher version of SQL Server.
So, you need to follow the below steps to create the Northwind database.
Step 1: Download the Microsoft's free sample Northwind database.
Download Northwind Database
Step 2: Install the Microsoft's free sample Northwind database.
For more details, please refer SQL Server 2014: Download and Install Northwind Database.
Once the installation is completed, you will find the Northwind Database and the script files in the following location.
Now, Right click on the instnwnd.sql file and click on Open with option from the context menu. Then click on SSMS 19 option.
Next, login to the database engine and you will see the file in the editor window.
After opening the file, comment the following lines from the script file.
exec sp_dboption 'Northwind','trunc. log on chkpt.','true'
exec sp_dboption 'Northwind','select into/bulkcopy','true'
GO
Finaally, click on Execute or press F5.
Thats it.
Now refresh the database and you will see the Northwind database.
