将多Windows应用程序连接到单个SqlServer [英] Connect Multi Windows Application into Single SqlServer

问题描述

我的一位客户在C＃.Net（ Windows应用程序）中询问他在不同位置的44个陈列室分支...他们要求所有分支数据将存储在单个Sql服务器中..



我的问题是如何在一个SQLServer中互连所有展示厅数据....展厅位于不同的位置..我可以连接它们...... />


请详细说明代码....先谢谢....

One of my client asking Project in C#.Net(Windows application) for his 44 Showroom Branches in Different Location...they demand all branches data will be stored in Single Sql Sever..

My Question is how can i interconnect all show room data in One SQLServer....Showroom located in different location..how can i Connect them...

Pls elaborate with Code....Thanks in Advance....

推荐答案

As Rockstar _ 在评论中写道：您需要在具有静态IP的单台机器上安装SQL Server，然后您需要配置SQL Server以启用远程连接。



以下是一系列有用信息：

如何在SQL Server 2008中启用远程连接？ [ ^ ]

配置远程访问服务器配置选项 [ ^ ]

配置Windows防火墙以允许SQL Server访问 [ ^ ]

http://www.connectionstrings.com/ [<一个href =http://www.connectionstrings.com/target =_ blanktitle =新窗口> ^ ]

As Rockstar_ wrote in comment: you need to install SQL server on single machine with static IP, then you need to configure SQL Server to enable remote connections.

Here is a collection of useful information:
How to enable remote connections in SQL Server 2008?[^]
Configure the remote access Server Configuration Option[^]
Configure the Windows Firewall to Allow SQL Server Access[^]
http://www.connectionstrings.com/[^]

这篇关于将多Windows应用程序连接到单个SqlServer的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！