如何从另一个系统连接sql server 2008 [英] how to connect sql server 2008 from another system

问题描述

如何从另一个系统连接sql server 2008?如果我尝试从另一个系统连接sql，则会显示错误

建立与SQL Server的连接时发生了与网络相关或特定于实例的错误.找不到服务器或无法访问该服务器.请验证实例名称正确并且将SQL Server配置为允许远程连接.(提供者:命名管道提供程序，错误:40-无法打开与SQL Server的连接)"

这是我的连接字符串
服务器="192.168.1.5/ADMIN"；初始目录= HMS；用户ID = sa；密码= xxxx;集成安全性= True

192.168.1.5-另一个系统IP地址

how to connect sql server 2008 from another system? if i try to connect sql from another system it shows the error

"A network-related or instance-specific error occurred 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 connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

this is my connection string
Server="192.168.1.5/ADMIN";initial catalog=HMS; User ID=sa; Password=xxxx; Integrated Security=True

192.168.1.5- Another systems IP number

推荐答案

服务器应为"192.168.1.5 \ ADMIN"，也称为管道连接，需要首先通过身份验证才能在连接到SQL Server之前先连接到计算机.

The server should be "192.168.1.5\ADMIN" , also named pipe connection requires you to be authenticated first to be able to connect to the computer before connecting to the sql server.

尝试检查要连接的SQL Server上是否允许远程连接.
允许远程连接

try to check whether remote connection are allowed or not on SQL server on which you want to connect.
allow remote connections

这篇关于如何从另一个系统连接sql server 2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！