Do I need to install microsoft sql server or it comes as by default with visual studio community 2017?

user_10611663 0
Viewed 3096

I have installed visual studio community 2017. Now I want to use database inside my application but i

TITLE: Error
------------------------------

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

The system cannot find the file specified

------------------------------
BUTTONS:

OK
------------------------------

i Can someone tell me what I an doing wrong ?

visual-studio-2017 sql-server asp.net database c#
2 Answers
user_20939170

It does not come by default with Visual Studio. But you get LocalDB out of the box which is a compatible light-weight development version of SQL Server Express and should for the most part serve your needs. For that you only need to tick certain checkboxes during the installation process, your Visual Studio installation can also be modified later on, see this very helpful post here:

How to install LocalDB 2016 along with Visual Studio 2017?

user_30609920
Related