连接远程服务器失败 [英] Failed to connect remote server

问题描述

大家好，
我已经在服务器上的sqlserver2008中创建了一个数据库，我为tat创建了登录名并为其分配了一些角色，我想远程连接此数据库，我已经在服务器上执行了以下步骤
1-启用TCP/IP
2-重新启动sqlserver
3-添加例外到Windows防火墙，sqlserver(进程)& oso端口1433
但是当我尝试使用服务器的IP地址从sql服务器实例连接到tat远程sql服务器时，SQL身份验证，登录名和密码出现以下错误msg，

建立与sql server的连接时发生与网络相关的错误或实例指定的错误.找不到服务器或无法访问该服务器.请验证实例名称正确且sql server配置为允许远程连接(提供程序:命名管道)提供程序，错误40-无法打开与sql server的连接)(Microsoft sql server Error，53)'
我搜索过很多东西，但是没人给我一个清晰的主意，请帮我解决这个问题

Mehboob
巴基斯坦

Hi everybody,
I had made a database in sqlserver2008 on server,i create the login for tat & assign it some roles,i want to connect this databse remotely,i had made the following steps on the server
1- enable TCP/IP
2- restart the sqlserver
3- add exception to windows firewall,sqlserver(process) & oso port 1433
but when i try to connect from my sql server instance to tat remote sql server using the IP address of the server,Sql authentication,login & password i get the following error msg,

''A network related or instance specified error occured while establishing a connection to sql server.The server was not found or was not accessible.verify that the instance name is correct and that sql server is configured to allow remote connection (Provider: Named pipes provider,error 40- could not open a connection to sql server)(Microsoft sql server Error, 53) ''
i had serached alot but nobody gaves me a clean idea,plz help me in this regrad

Mehboob
Pakistan

推荐答案

可能有多种原因.这些链接应该可以帮助您:
链接2 [

There can be various reasons for the same. These links should help you out:
Link 1[^]
Link 2[^]
:thumbsup:

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