Solved

Multiple users using a WinForm application / MS SQL 2008 Express

Posted on 2008-10-14
2
778 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
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…

752 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