通过IP，端口号访问远程SQL Server的问题.如何完整配置 [英] Problem with accessing Remote SQL Server by IP, PortNo. How to Configure it Completely

问题描述

我正在连接到具有静态IP的远程SQL Server.
我也为MSSQLSERVER和SQLEXPRESS启用了TCP/IP和Named管道.
我正在使用以下连接字符串:

I am connecting to a remote SQL server have static IP .
I enabled the TCP/IP and Named pipe for MSSQLSERVER and SQLEXPRESS also.
I am using the following connection string:

"Integrated Security=False;Initial Catalog=DB1;Data Source=tcp:100.100.182.219,80;user id=user;password=user123;"

但是我无法连接到远程SQL Server.如何完全配置远程SQl服务器.有什么解决办法吗?

But I am unable to connect to Remote SQL Server.How to Configure Remote SQl Server Completely. Are there any solution for this.

While opening the connection I am getting the following error :<br />
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

所有步骤都需要做什么?我在哪里犯错?

谢谢，谢谢..
感谢您的答复
谢谢您

What all steps are required, and where I am making the mistake?

Please reply,Thanx..
Appreciate Your reply
Thanking You

推荐答案

我回复了您一段时间.好像您删除了先前的问题.请避免这种情况.如前所述:

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

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

如果这不能解决您的问题，请查看以下线程:
http://forums.asp.net/t/1334649.aspx [ SQL服务器修复错误(提供者:命名管道 [

I replied you some time back. Looks like you deleted your earlier question. Kindly avoid that. As said:

It might be 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..

If this does not resolve your issue, have a look at these thread:
http://forums.asp.net/t/1334649.aspx[^]
SQL SERVER FIX ERROR (provider: Named Pipes [^]
Quite few possible reasons and resolutions are proposed here too.

这篇关于通过IP，端口号访问远程SQL Server的问题.如何完整配置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！