I will continue in this Forum area to discuss how to get into SQL Server - acquiring the right tools and moving towards our own code in X# syntax to access and create data in SQL tables.
Here is a starting image - installing a new version of the free MS Management Studio 17 and attaching a supplied database named "StockCodeFirst_L2S", which I will supply. We will find out later what 'Code First' means, as well as 'Linq to SQL' (L2S).
For those who are interested in such matters, I am now going to set up a Windows 10 'Hyper-V' virtual machine to keep all my VS 2017, SQL Server 2016, Management Studio 17, and other stuff quite separate to the rest of my desktop general purpose stuff. That way I may be able to get a working 'clean' VS 2017 Enterprise installation up and running - I have currently over-used the Installer for VS 2017 and nothing works except VS 2015 Pro.
P.S. as a first try to provide a suitable small database, try this 'RARed' file pair :-
I have tried another version of SQL Server but it still causes a crash for my VO 2.6 setup. Right now I am on WIN 10 Home and cannot istall Hyper V. Need to look for an alternative or check to upgradse to WIN 10 Pro.
I thought I was ready...Need a little bit more time to find a solution.
Take care with what you install and change - there is always more too things than meets the eye !
You need a stable Windows 10 set-up on which to build. I suggest a x64 version if your hardware will allow it, and you also need plenty of free disk space.
Can you get a version above 'Home' ? There my be restrictions to a 'Home' edition which may bite you (us) later.
And for now, do not go anywhere near 'Hyper-V'. If you are having issues with SQL Server on standard Windows then we don't need more issues ;-0) I am using Hyper-V as a last ditch solution to my VS 2017 install problems, no other reason. And I have done a lot of previous work with Hyper-V, which should help.
I am surprised you are having issues, as MSSS has always behaved well for me on O/S even before Vista. What other old software have you got installed ?
as of now I am just experiencing issues with VO (but haven't tested all apps yet). I am currently checking if i can upgrade to PRO (without spending €155 in the MS Shop). I have tried this a few months ago but MS told me I need to install completly new. Now I found out that it might be possible to upgrade from OEM Home to PRO without a complete reinstall.
I think my machine is well equiped. As soon as I have more information I will let you know.
I am also making some progress. I have upgraded my WIN 10 home to Pro for a few €'s. Next step is installing a VM with VS 2017 und SQL Server. Based on your note this seems to work fine. I should be ready by tomorrow and will let you know.
Enjoy soccer (assuming it is not the US "football"). What is your team?