SQL Server 5 client connection limit for a web ap.

[Brian Cryer]

I'm developing using VB.Net and on our test server I have MSDE installed. My
project manager is keen for us to install SQL Server with 5 client licenses
for our live server (instead of MSDE). My biggest concern is that with SQL
Server presumably I will start getting connection errors if we have more
than 5 users hitting the site at the same time.

Whilst I'm sure I ought to be able to simulate it, does anyone know (1.)
what error I would get back and (2.) whether there would be any reason why a
simple sleep + retry on this error wouldn't get around the problem
(performance issues aside)?

thanks,

Brian Cryer.

 

[Cor Ligthert]

Brian,

I don't believe you can get problems so first try it, and when you have
problems than the connection.timeout setting is the first area to look for
in my opinion.

http://msdn.microsoft.com/library/d...tsqlconnectionclassconnectiontimeouttopic.asp

I hope this helps?

Cor

 

[Brian Cryer]

Brian,

I don't believe you can get problems so first try it, and when you have
problems than the connection.timeout setting is the first area to look for
in my opinion.

http://msdn.microsoft.com/library/d...tsqlconnectionclassconnectiontimeouttopic.asp

I hope this helps?

Cor

Thanks Cor, I'll have a play.