Solved

Multiple users using a WinForm application / MS SQL 2008 Express

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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 …
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

895 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

17 Experts available now in Live!

Get 1:1 Help Now