Solved

Multiple users using a WinForm application / MS SQL 2008 Express

Posted on 2008-10-14
2
761 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

758 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now