远程连接sql server [英] connect sql server remotely

问题描述

你好

我无法远程连接到sql服务器我已经完成了sql服务器浏览器，所有连接的防火墙以及sql server以允许远程联系.当我尝试通过我的C#应用​​程序进行连接时，我不断收到错误消息 cod e.因此，我做了新的登录用户名&通过，但仍然出现相同的错误.我正在通过交换机连接服务器IP:192.168.1.100，我的客户端是 :192.168.1.105.当我ping服务器IP或客户端IP时，得到响应，但是我使用的是服务器名称，它给了我错误消息.

I've problem with connecting to sql sever remotely I'm done sql server browser , the fire wall to all connection , and sql server to allow remote connection. when I try to connect through my c# app ,I keep getting error code . So , I did new login  username & pass, but still the same error keep showing up. I'm connecting through switch my server IP:192.168.1.100 , my client is :192.168.1.105. when I ping the server IP or client IP ,I get a response ,but I'm using server name it gave me error message.

推荐答案

通常，当您可以不使用Visual Studio而连接到PC上的服务器并且不能使用Visual Studio时，这表明您需要证书.   默认证书"指的是默认证书". Net Library中的文件使用与您的IE浏览器相同的凭据 与任何Cookie和代理设置一起使用.您没有具体说明要使用哪种方法进行连接，因此我无法为您提供需要添加的几行代码.如果发布连接代码(您可以更改网址 和服务器名称)，我会尽力为您提供正确的解决方案.

Normally when you can connect to a server on the PC without using Visual Studio and can't with Visual Studio it is an indication that you need a credential.  The "default credentials" in Net Library uses the same credentials the your IE browser would use along with any cookies and proxy settings.  You didn't stpecify which method you are using to make the connection so I can't give you the couple of lines of code that you need to add.   If you post your connection code (you can change url and server name) I will try to give you the correct solution.

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