需要有关使用SQL Server Express的专家建议 [英] Need expert advice on use of SQL Server Express

问题描述

我有一个带有SQL Server Express数据库的应用程序.
我制作了一个SQL Server Express实例，并将其与用于测试的基本报告相连.在开发服务器上，它可以正常工作.
然后我共享了该文件夹，然后从其他网络计算机(LAN)运行了该应用程序.
它给出了找不到服务器的错误.

1)您能告诉我可能是什么问题吗?
2)同样，当此应用程序安装在另一台计算机上时，我的数据连接如何进行自我调整.当前的数据连接基于开发计算机上安装的SQL Server的服务器实例.
3)我的应用程序如何在客户端的任何计算机上自动创建新的服务器实例并连接到它?就像Inflow一样，无论安装在哪里，它都会创建InflowSQL实例.

谢谢

Hi,
I have an application, with SQL Server Express Database.
I made an instance of SQL Server Express and connected it with a basic report for testing. On the development server, it works ok.
Then I shared the folder and then ran the application from some other network computer (LAN)
It gave error that it could not find the server.

1) Could you advise what could be the problem.
2) Also when this application is installed on another computer, how does my dataconnection adjust itself. The current dataconnection is based in the server instance of SQL Server installed on my development computer.
3) How does my application automatically create new server instance on any of client''s computer and connects to it? Like Inflow creates InflowSQL instance wherever it is installed.

Thanks

推荐答案

我的应用程序如何在任何客户端计算机上自动创建新的服务器实例"
你没有！

那是灾难的秘诀.

他们可能已经在网络上安装了SQL Server.如果是这样，那么他们大概会想使用该版本.
如果他们确实安装了SQL Server，并且您开始扩散SQL Server Express实例，那么您将使数据库管理员大为恼火...
与用户控制下的多个分散版本相比，备份SQl Server的单个站点安装的可能性要大得多.
对于普通"用户而言，Sql Server的安装和管理非常复杂-这不是一个好主意！
它将破坏使用SqlServer而不是SqlCE或SQLite的主要优势-多用户访问.如果每个人都安装了自己的SQL Server副本，那么您将拥有数据库的多个副本，每个副本都由一个人使用.这将引起一些混乱，并且(取决于您编写原始数据库的方式)在实现问题后可能需要花费大量精力才能组合成一个实例.

"How does my application automatically create new server instance on any of client''s computer"
You don''t!

That is a recipe for disaster.

They may already have SQL Server installed on the network. If so, then they will presumably want to use that version.
If they do have SQL server installed and you start proliferating SQL server Express instances, you are going to annoy the heck out of the database administrator...
A single site installation of SQl Server is a lot more likely to be backed up than a number of scattered version under user control.
Sql server is quite complex for a "normal" user to install and administer - it is not a good idea!
It will destroy the primary advantage of using Sql Server over SqlCE or SQLite - multiuser access. If everyone installs their own copy of SQL server, then you will have multiple copies of your database, each used by a single person. This will cause some confusion, and (depending on how you wrote the original database) may take some considerable effort to combine into a single instance when the problem is realized.

我认为您应该阅读有关连接到SQL Server时使用的连接机制的信息.连接字符串是用于定位某些数据库实例的表示形式，该数据库实例使用适当的凭据位于其中.

- SQL Server连接基础 [ SQL Server浏览器服务 [

I think you should read about the connection mechanisms used when connecting to SQL Server. The connection string is the representation to locate certain database instance, a database inside it using proper credentials.

- SQL Server Connection Basics[^]
- SQL Server Browser Service[^]

这篇关于需要有关使用SQL Server Express的专家建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！