Saturday 3 November 2018

A network-related or instance-specific error ocurred while establishing a connection to SQL Server. The server was not found or was not accessivle. 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)


A network-related or instance-specific error ocurred while establishing a connection to SQL Server. The server was not found or was not accessivle. 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)


                      If this error comes when trying to connect with Database from the Visual Studio Project through Entityframework , then open Control Panel and search for Services in Search bar and In the Administrative Tools click on View Local Services and find SQl Server Browser and the Startup Type may be disabled, then right click on it and select Properties in the displayed menu. And in the displayed SQL Server Browser Properties window, in General tab change the Startup type to Automatic and click on Ok button, Now again start to add ADO.NET Entity Data Model in your project, now it will works with out error., follow the steps shown in images :












No comments:

Post a Comment

Note: only a member of this blog may post a comment.