基于LAN的应用程序 [英] LAN based application

问题描述

Hello开发人员，



我将开发一个基于LAN Server的应用程序，其中 -



1.应用程序将安装在将连接到LAN的客户端PC上。

2.数据库将在LAN服务器计算机中。

3.我将使用SQL Server 2008

4.前端将在C＃或VB中



问题 -



1.如何配置sql server通过LAN连接？

2.什么是连接字符串？



请给我合适的解决方案。



提前致谢

Hello developers,

I am going to develop an LAN Server based application in which -

1. Application will be installed on client PC which will connected to LAN.
2. Database will be in LAN Server computer.
3. I will use SQL Server 2008
4. Front-end will be in C# or VB

Problem -

1. How to configure sql server to connect through LAN?
2. What will be the connection string?

Please give me proper solution.

Thanks in advance

推荐答案

1. 您需要配置SQL Server以允许远程访问：如何配置SQL Server 2005以允许远程连接 [ ^ ]
2. 关于我的连接字符串的最佳资源是 SQL Server连接字符串 [ ^ ]

1. You need to configure SQL Server to allow remote access: How to configure SQL Server 2005 to allow remote connections[^]
2. The best resource for how-tos on connections strings for me is SQL Server connection strings[^]

问候，

- Manfred

亲爱的朋友，



您可以给出如下连接字符串： -

Dear Friend,

You can give connection string like this:-

Data Source=computer-name;
Initial Catalog=abcd;
Persist Security Info=True;
User ID=sa;
Password=admin1234;
Pooling=False

您可以将服务器计算机名称作为数据源，

数据库名称作为初始目录，

您可以提供用户ID和密码来连接数据库。



hope你明白了。



问候，



Sunil

You can give server computer name as data source,
database name as initial catalog,
you can give user ID and password for connecting to the database.

hope you understood.

with regards,

Sunil

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