January 12, 2009 at 12:12 pm
Hi,
When more than 5 users access one DB in SQL Express 2005 through a Visual Basic 2005 application, the SQL Service stops! Then I manually restart the service and it keeps running until the 5 concurrent users access the system again.
Is this normal? Is there something I can do to prevent this?
Thank you,
Renato.
January 12, 2009 at 12:15 pm
SQL Express doesn't do well with more than 1 or 2 users. Shouldn't stop, but I bet if you check the error logs, you'll find some high-severity issue coming up.
For low-end databases with 5-10 users, I'd generally go with Workgroup, over Express.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 13, 2009 at 7:41 am
Can you check it restrictions apply to the number of user connections ?
/* "user connections" is an advanced config setting
enable show advanced options */
exec sp_configure 'show advanced options' , 1
reconfigure
go
/*results (on my dev-edtn server)
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
*/
/* show config value */
exec sp_configure 'user connections'
go
/*results (on my dev-edtn server)
name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
user connections 0 32767 0 0
*/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply