Win Server 2008 Foundation - SqlServer 2008 stops to accept connections?

Windows Server 2008 Foundation limits include.

Up vote 0 down vote favorite share g+ share fb share tw.

I have a server machine with Windows 2008 Server R2 Foundation installed, that I use for hosting SqlServer 2008 service. There is no additional user registered on the OS, the clients asks only for connection with sqlserver. I've notice that periodically some clients stop working when trying to connect to sqlserver, while in the same time other clients are working properly.

I know there are some limits on concurrent connections for foundation edition, but I can't understand which limit I'm breaking. Some ideas? Sql-server-2008 limit foundation windows-server link|improve this question edited Jun 4 '11 at 13:22marc_s175k14142283 asked Jun 4 '11 at 13:20g1ga574.

You might find some help for this at dba.stackexchange.com. – DOK Jun 4 '11 at 13:24.

Windows Server 2008 Foundation limits include: 15 User Limit 50 TS Connections 50 RRAS Connections 10 TAS Connections 30 SMB Connections 1 socket systems only 8GB maximum memory support No virtualization use right from: msmvps.com/blogs/bradley/archive/2009/08... You can run sp_who and see all the connections that are being used but based on my understanding 30 is the limit.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.