无法从远程连接到SQL Server [英] cannot connect to sql server from remote

问题描述

亲爱的所有人，我正在尝试使用具有波纹管连接字符串的c#连接到SQL Server

Dear All, I am trying to connect to SQL Server using c# with bellow connection string

Data Source=xxxx;Initial Catalog=db;Persist Security Info=True;User ID=xxx;Password=xxx;Connect Timeout=60

我还在SQL Server(TCP/IP和名称管道)中启用了远程连接，并且出现以下错误:
已成功与服务器建立连接，但是在登录过程中发生了错误. (提供者:TCP提供程序，错误-指定的网络名称不再可用.)

有任何想法为什么会出现错误?

I also enabled remote connection in sql server (TCP/IP and Name Pipes) and i am getting bellow error:
A connection was successfully established with the server, but then an error occurred during the login process. (provider:TCP Provider, error - The specified network name is no longer available.)

any ideas why the error appears?

推荐答案

如果错误是:
已成功与服务器建立连接，但是在登录过程中发生错误.

那么用户名/密码的组合不正确.

if the error is:
A connection was successfully established with the server, but then an error occurred during the login process.

then the combination of username/password is incorrect.

谢谢，我发现，ISP不允许通过其策略使用端口1433.

Thanks, I find it, ISP didn''t allow port 1433 through their policy.

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