如何从另一个PC访问Sql Server？ [英] How Do I Access Sql Server From Another Pc?

问题描述

connetionString =Data Source = 172.21.1.91,16000; Network Library = DBMSSOCN; Initial Catalog = EnqInfo; User Id = Promod; Password = P @ 19861030; Integrated Security = True;



i分配了这样的连接字符串？



坚果它给了我和错误信息说，



您的应用程序中发生了未处理的异常。如果单击继续，应用程序将忽略此错误并尝试继续，如果单击退出，应用程序将立即关闭



与网络相关的实例或实例建立与sql server的连接时发生错误。找不到服务器或无法访问服务器。验证实例名称是否正确，并且sql server配置为允许远程cinnections。 （提供者：TCP提供者，错误0-！连接尝试失败，因为连接方在一段时间tym之后没有正确响应，或者建立的连接失败，因为连接主机未能响应）。

connetionString = "Data Source=172.21.1.91,16000; Network Library=DBMSSOCN; Initial Catalog=EnqInfo; User Id=Promod;Password=P@19861030;Integrated Security=True";

i assigned my connection string like this?

nut it gives me and error message saying,

Unhandled exception has occured in yout application. if you click to continue, the application will ignore this error and attempt to continue, if you click quit, the application will close immediately

A network related instance or instance specific error occured while establishing a connection to sql server. the server was not found or not accessible. Verify that the instance name is correct and that sql server is configured to allow remote cinnections. (provider : TCP Provider, error 0-! connection attempt failed because the connected party did not properly respond after a period tym, or established connection failed becaues connected host has failed to respond).

推荐答案

您已经多次询问此问题（以及相关问题）。您是否浏览了此处提供的链接 [ ^ ]？



如果有，请发布您的调查结果和您遇到的其他相关信息。



你问的问题是一个典型的问题，但不幸的是没有一个简单而准确的答案。基本上，错误意味着您的客户端无法与服务器通信，因为某些内容阻止了对话。这可以是应用程序之间的任何地方。



所以请花点时间，阅读解决方案并尝试不同的方法。

You have asked this (and related questions) a few times. Have you gone through the links provided here[^]?

If you have, post your findings and other relevant information you have encountered.

The question you're asking is a typical problem but unfortunately there's no one, simple and exact answer. Basically the error means that your client can't communicate with the server because something is blocking the conversation. This can be anywhere between the applications.

So take your time, read about the solving possibilities and try different approaches.

这篇关于如何从另一个PC访问Sql Server？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！