sql连接问题 [英] sql connection problem

问题描述

为什么我的visual studio会显示此消息。

建立与SQL Server的连接时发生网络相关或实例特定错误。服务器不是发现或无法访问。验证实例名称是否正确，并且SQL服务器配置为允许远程连接。

我为wordpress工作安装了wamp服务器。这与我的wamp服务器有冲突吗？请告诉我一个解决方案。

Why my visual studio show this message.
"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 the instance name is correct and that SQL server is configured to allow remote connection."
I install wamp server for my wordpress work. Is this conflict with my wamp server. please tell me a solution.

推荐答案

您可以找到大量相似的问题和解答此处 [ ^ ]。



请参考这个：如何在网络中枚举SQL Server实例[ ^ ]。

Tons of similar questions and answers you'll find here[^].

Please, refer this tooo: How to enum SQL Server instances in network[^].

可能的问题是您传递以连接到服务器的连接字符串。根据下面的任何可能的问题，将抛出错误，

• 首先要确保你'为SQL服务器或数据库传递正确的名称。如果没有，请更正。
• 使用您在创建数据库时使用的用户名和密码。
• 您应该考虑了解connectionString必须具有所有必需的身份验证数据使您的应用程序可以使用它。因此，如果您使用Windows authenticiticaion为其创建字符串，否则如果您使用数据库身份验证，则使用它的设置;用户名密码组合。

The possible issues are the connectionstring that you're passing to connect to the server. The error would be thrown depending on any possible issues below,

• First thing is to make sure that you're passing the correct name for the SQL server or the database. If not, please correct it.
• Use the username and password that you used while creating the database.
• You should consider understanding that the connectionString must have all of the required authentication data before enabling your application to use it. So, if you used Windows authenticaion create a string for that, otherwise if you used Database authentication then use the settings for it; username password combination.

这篇关于sql连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！