错误连接到"SQL Server 2008数据库项目使用Visual Studio 2010 [英] Error Connect to server in " SQL Server 2008 Database Project " with Visual Studio 2010

问题描述

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: 2)


What do i must to do?

推荐答案

可能有很多可能的事情，我们在这里不能真正介绍.

在这里看看:它涵盖了最受欢迎的7个原因: http://www.sswug.org/articlesection /default.aspx?TargetID=44331 [ ^ ]

但是它确实错过了一个机会:您是否已将SqlServer安装在实际上可以使用的地方?" -如果我是你，我会先检查一下！ :laugh:

There are so many possible things it could be, that we can''t really cover them here.

Have a look here: it covers the most popular 7 reasons: http://www.sswug.org/articlesection/default.aspx?TargetID=44331[^]

But it does miss one out: "Have you installed SqlServer somewhere you can actually get at it?" - I''d check that one first, if I was you! :laugh:

通常是外围应用配置错误或 sql服务配置问题.请查看此线程的潜在原因和解决方法: ^ ]

如果需要，请在此处参见设置外围应用配置的步骤. .

在这里，请查看以下与之相关的博客条目:
在默认设置下，SQL Server不允许远程连接 [ ^ ]
它说:
I.确保在外围应用配置器"工具中启用了远程连接"
二.检查是否在SQL Server配置管理器中启用了TCP/IP协议
三，确保SQL Server Browser服务正在运行

Generally, it is surface area configuration error or sql service configuration issue. Have a look at this thread for potential reasons and resolutions: Resolving A network-related or instance-specific error occurred while establishing a connection to SQL Server[^]

If needed, See steps for setting up Surface area configuration here..

Here, look at the following blog entries related to the same:
Under the default settings SQL Server does not allow remote connections[^]
It says:
I. Make sure that Remote Connections are enabled in Surface Area Configuration tool
II. Check Whether TCP/IP protocol is enabled in the SQL Server Configuration Manager
III. Make sure that SQL server Browser service is running

通常，这是外围应用配置错误或 sql服务配置问题.请查看此线程的潜在原因和解决方法: ^ ]

如果需要，请在此处参见设置外围应用配置的步骤. .

在这里，请查看以下与之相关的博客条目:
在默认设置下，SQL Server不允许远程连接 [ ^ ]
它说:
I.确保在外围应用配置器"工具中启用了远程连接"
二.检查是否在SQL Server配置管理器中启用了TCP/IP协议
三，确保SQL Server浏览器服务正在运行

Generally, it is surface area configuration error or sql service configuration issue. Have a look at this thread for potential reasons and resolutions: Resolving A network-related or instance-specific error occurred while establishing a connection to SQL Server[^]

If needed, See steps for setting up Surface area configuration here..

Here, look at the following blog entries related to the same:
Under the default settings SQL Server does not allow remote connections[^]
It says:
I. Make sure that Remote Connections are enabled in Surface Area Configuration tool
II. Check Whether TCP/IP protocol is enabled in the SQL Server Configuration Manager
III. Make sure that SQL server Browser service is running

这篇关于错误连接到"SQL Server 2008数据库项目使用Visual Studio 2010的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！