错误创建在Visual Studio中的SQL Server数据库 [英] Error creating an SQL Server Database in Visual Studio

问题描述

我想创建在Visual Studio 2010中一个新的SQL数据库，并在输入服务器名和数据库名称，然后pressing好吧，我得到这个错误。

I am trying to create a new SQL DB in Visual Studio 2010, and Upon entering a Server Name and a DB name then pressing Ok, I get this error.

建立SQL Server的连接时发生网络相关的或特定于实例的错误。服务器未找到或无法访问。验证实例名称是否正确，以及SQL Server配置为允许远程连接。 （provider：命名管道提供程序，error：40 - 无法打开到SQL Server的连接）

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)

任何想法？

推荐答案

只是通过这个article.I认为你能解决这个问题。
<一href=\"http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/\" rel=\"nofollow\">http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

Just go through this article.I think you can solve the problem. http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

另外，还要确保您已指定服务器和数据库名称正确连接带string.just连接字符串添加从数据库属性窗口。

Also ensure you have specified servername and database name correctly in connection string.just take connection string from property window of added database.

这篇关于错误创建在Visual Studio中的SQL Server数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！