LAN中的SQL Server 2008连接 [英] SQL server 2008 connection in LAN

问题描述

Helo



我使用VB.NET和SQL Server 2008创建了一个Windows应用程序。我在其中一个系统中安装了SQL服务器并提供了sql server身份验证。它工作正常。但问题是我无法使用与其他系统的sql server相同的IP地址登录..我怎么能解决这个问题（我不知道是否可以这样做）

i给定的服务器名称：192.168.1.19 \ SVQPRESS

用户名：ajantha_sw

pswrd：*******就像那样........

Helo

I have created a windows application using VB.NET and SQL server 2008. I installed SQL server in one of the system and give sql server authentication. It works fine. But the problem is that i am not able to login with the same IP address with other system''s sql server.. How can i solve that( i dont know is it possible to do like that)
i given server name : 192.168.1.19\SQLEXPRESS
username : ajantha_sw
pswrd :******* like that........

推荐答案

如果您的机器有多个实例，那么您需要指定实例名称。

其他明智的只使用IP /名称。



请检查SQL服务器运行的端口



通过sysadmin运行此查询

Hi,

If you machine have multiple instance then, you need to specify the instance name.
Other wise use only IP/ Name.

Please check on which port SQL server is running

Run this Query through sysadmin

SELECT
    e.name as ProtocolName
    ,ec.local_tcp_port as Port
    ,ec.local_net_address as IP
FROM
    sys.endpoints e
LEFT JOIN
    sys.dm_exec_connections ec
ON
    ec.endpoint_id = e.endpoint_id
where
      e.name = 'TSQL Default TCP'
GROUP BY
    e.name
    ,ec.local_tcp_port
    ,ec.local_net_address

然后使用IP，端口再试一次。

Then use IP,Port and try again.

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