How to set up SQL Server?

Question

.NET

When trying to create a new database, Sql Server gives the error "Could not open connection to SQL Server".
I read and found out that this is due to the fact that I did not install SQL Server Browser. It seems to me that it is part of Management Studio. But I have no way to install Management Studio.
In general, I'm learning C# .NET from Troelsen's book. Reached the head of ADO.NET. The author asked to install SQL Server.
What do i do? Is there any other way to learn ADO.NET normally without SQL Server? Maybe you can somehow solve the problem with SQL Server Browser? Maybe it can be installed without Management Studio?

Answer 1

You can use MSSQL Compact, a kind of sqlite analogue, native MSSQL syntax. And, in principle, it is not necessary to install SQL Server Browser. You can work with the database using Visual Studio, take the 2013 Community.
Poke around erikej.blogspot.ru/2009/04/sql-compact-3rd-party-t ... there are links to third-party products.

Answer 2

During installation, you need to allow downloading and installing updates, then everything will work.