do connection limits affect sql server?

[jennyflower]

Hi, I have been trying to find out whether the 10 user connection limit on xp and vista will affect how many users can connect to a sql server database. The database user will always be the same (at the moment I am using the sa user). I have tried to test it but I don't really understand the connection limit thing in full.

Thanks

 

[Crowley16]

are you talking about remote desktop connections?


--------------------
Procrastinate Now!

 

[mrdenny]

No SQL Server is not limited by the Windows XP / Windows Vista 10 conection limit.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[jennyflower]

Thanks, is it not affected by the 10 connections per second thing either then?

 

[mrdenny]

SQL Server isn't limited by the Windows connection limits. If you are using MSDE for SQL 2000 then you have some limits which come from MSDE. SQL Express doesn't have that problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com