Solved

Multiple users using a WinForm application / MS SQL 2008 Express

Posted on 2008-10-14
2
767 Views
Last Modified: 2012-05-05
Hi Experts,
I have built a WinForm application using VB.Net and MS SQL 2008 Express.

All files are currently located on the c: drive. I now want several users to use the application at the same time. All users are connected to (local) our business network. I have some questions regarding the correct deployment:
1. Is there a limitation regarding the number of concurrent users connected to MS SQL 2008 Express?
2. I want to install MS SQL 2008 Express on a network server and connect the database to that server. Is this possible with MS SQL 2008 Express and is it then possible for all users in the network to connect to the database?

Help is as always appreciated,
Regards, MB
0
Comment
Question by:mark_norge
2 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 250 total points
ID: 22709762
1.no limit
2. its possible
0
 
LVL 51

Assisted Solution

by:Mark Wills
Mark Wills earned 250 total points
ID: 22713164
There is no limit - size and memory do have limits, and a practical limit of around 20-50 is reasonable. And yes, it is a service based product so ideally suited to a server install. Would be using the Advanced Services version - and get that Managament Studio...

In other words, what momi_sabag said...
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL query with cast 38 43
MS SQL 2008 Divide by zero error encountered. Error 3 37
MS SQL Server Modify insert/update update to use MERGE 13 50
SqlServer no dupes 25 35
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question