I am studying for the MTA Software Fundamentals exam and going through the Wiley Book.
It tells me to try and connect the Northwind Database via Visual Studio (2017), but every time I do so, I am faced with an error (I have attached a picture).
“The database file that you are attempting to connect is not compatible with the current instance of SQL Server”.
I then try to upgrade the database file then it says:
“Database file cannot be upgraded because it’s a non-release version, its not supported by this version of SQL Server.”
I have tried uninstalling SQL 2014 (express) and installing 2012 (express).
I have looked at most posts on the web with the same issue but can’t deduce what the answer is telling me to do.
I’m extremely new to SQL, does anyone have a basic explanation on how to fix this? The practical exercises from the Wiley book seem to be extremely useful, so I'm not giving up!