'Cannot connect to SQL Server Browser. Ensure SQL Server Browser has been started

I'm trying to connect my ASP.NET Core MVC application to SQL Server. I'm using the Visual Studio for mac.

I wrote the connection string like below : 

"ConnectionStrings": {
   "DevDBConn": "Server={serverName}\\{instanceName};Database={DBName};User ID={userID};Password={password};Trusted_Connection=True;"
},

I'm pretty sure that my DB Server's info is correct, but I get this error:

System.Exception: Cannot connect to SQL Server Browser. Ensure SQL Server Browser has been started.
System.Net.Internals.SocketExceptionFactory+ExtendedSocketException (00000005, 0xFFFDFFFF): nodename nor servname provided, or not known

Does anyone have an idea why there is an error?

asp.netsql-serverasp.net-mvcasp.net-core-mvc


Solution 1:[1]

Open run command (WIN+R), press services.msc and press ENTER. The services are visible now. Check SQLServer (instance name) and SQL Server Browser are running.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Moloy Adhikary

Related Questions