500 connection limit WSUS

I have a WSUS 3.0 SP1 installed on a 2008 64-bit server.  I can't get more than 500 clients to show up under computers.  I have found after digging there might be a 500 connection limit on MSDE.  Does this limit apply to SQL Express 2005?  I don't really don't know if I am running MSDE 2000 or SQL Express 2005.  I have about 530 clients so I don't want to purchase the full version of SQL for 30 clients.

Any ideas or help would be great.

Thanks.
shuberttAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Don S.Commented:
WUSU 3.0 SP1 runs Windows internal database - which is SQL Express 2005.  There is no hard limit to connections to an SQL Express database, but there is a simulatneous thread limit the effectively limits the number of concurrent connections.   SQL express basically gets slower and slower the more simultaneous connections there are until it's mostly unusable.  I have over 800 computers in my environment, but I also have more than one WSUS server to handle them.  That may be a solution for you if you have more than one server.  Just install a second WSUS server and have it synch to the primary one, set different destinations either by GPO and OU or via DNS/subnet.
0
DonNetwork AdministratorCommented:
Your complete answer is here:

http://social.technet.microsoft.com/Forums/en-US/winserverwsus/thread/5c7c9daa-4132-4b39-8d0a-a50daf0e34f7


Lawrence Garvin is one of the most knowledgeable on the subject of WSUS.


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MightySWCommented:
Do you have a copy of SQL?  If so, try it out on a virtual machine, move the DB and try it.  

If it works then we will know that the theory is incorrect on MSDE.  Not LG's fault, but you can blame this one on MS...  And Dstew.
0
DonNetwork AdministratorCommented:
Recommend accept ID:24853350
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.