如何共享SQL数据库 [英] How to Share SQL Database

问题描述

我有一个用C＃winforms构建的应用程序。在后端我使用的是SQLSERVER 2008 Express。该应用程序通过瘦客户端远程使用。



我的问题是当一个用户使用我的软件而第二个用户试图打开软件并尝试制作任何软件时对数据库进行操作，数据库拒绝连接。只有当第一个用户关闭应用程序时，第二个用户才能操作数据库查询。

I am having one application built in C# winforms. In the backend I am using SQLSERVER 2008 Express. The application is used remotely through thin clients.

My problem is that when one user is using my software and a 2nd user tries to open the software and tries to make any operation on the database, the database refuses to connect. Only when the first user closes the application, the second user can operate the database queries.

推荐答案

您需要设置SQL Express以允许远程连接



http：//blogs.msdn .com / b / sqlexpress / archive / 2005/05/05 / 415084.aspx [ ^ ]



还要检查以确保数据库不在单个用户模式。

You need to set SQL Express to allow remote connections

http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx[^]

also check to make sure that the database is not in single user mode.

检查以下链接以共享Db： -

http://stackoverflow.com/questions/6667400/how-to-connect-database-over-local-area-network-sql- server-2008 [ ^ ]

http://stackoverflow.com/questions/12881455/sql-server-database-on-network-share [ ^ ]

http://stackoverflow.com/questions/19146281/how-to-connect-to-sql-server -database-via-lan [ ^ ]

check below links for sharing Db:-
http://stackoverflow.com/questions/6667400/how-to-connect-database-over-local-area-network-sql-server-2008[^]
http://stackoverflow.com/questions/12881455/sql-server-database-on-network-share[^]
http://stackoverflow.com/questions/19146281/how-to-connect-to-sql-server-database-via-lan[^]

为您的应用程序使用断开连接的ADO.net体系结构。

use disconnected ADO.net architecture for your application.

这篇关于如何共享SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！