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.