Issue: Visual Studio Connect to Microsoft SQL Server Database Failed – A network-related or instance-specific error occurred
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: 1326)
Description: When attempting to connect to a database from Visual Studio, if you are getting a message from Visual Studio Data Connection that it was not able to connect to SQL Server, check the following workaround.