Sql server数据库无法在Lan中连接 [英] Sql server database could not connect in Lan

问题描述

嗨
我正在通过vs 2008和sqlserver 2008开发窗口应用程序。它在我的系统中运行完美。但。我需要安装和访问我的应用程序到多个系统。所以我把一个系统作为服务器。我只在我的服务器上安装了sql server。它完全由（本地）运行。但我无法通过LAN访问Db

这是我的连接字符串

数据源= MyServer;初始值Catalog = SampleDb;用户ID = sa;密码= abc 

。



它无法通过局域网工作。是sqlserver产品中的任何配置。帮助解决它。

解决方案

首先，你需要检查几件事：

1. SQL Server配置中是否启用了TCP / IP？

2. Windows防火墙是否阻止SQL Server端口？

3。 SQL Server Management中是否启用了远程连接？



请参考这篇文章：

SQL Server Manager无法连接到远程数据库 [ ^ ]

Hi i am developing window application through vs 2008 and sqlserver 2008. its running perfectly in my system. but. i need to install and access my application to multiple system. so i put one system as server. i installed sql server in my server only. its running perfectly by (local). but i cannt access Db through LAN
Here is my connection string

Data Source=MyServer;Initial Catalog=SampleDb;User ID=sa;Password=abc

.

Its not working through LAN. Is any configuration in sqlserver product. help to resolve it.

解决方案

Hi,

First of all, you need to check several things:
1. Is TCP / IP enabled in SQL Server Configuration?
2. Is Windows Firewall not blocking SQL Server port?
3. Are remote connections enabled in SQL Server Management?

Please refer to this post:
SQL Server Manager can not connect to a remote database[^]

这篇关于Sql server数据库无法在Lan中连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！