Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Maximum Simultaneous Connections

Author  Topic 

suchiate
Starting Member

33 Posts

Posted - 2008-02-14 : 22:16:18
Hi All,

I have a Windows 2003 Server. Planning to use SQL Server to act as the main Database Server which needs to cater to over 100's of simultaneous connections.

Can anyone share with me the default maximum simultaneous connections and the maximum allowed simultaneous connections for the following versions:

- MSDE
- 2000
- 2005 Express
- 2005

Hope I can get more professional advice from you guys.

Thanks.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-16 : 14:28:53
You can find them in sql books online, max sql server connections is 32767 except msde.
Go to Top of Page
   

- Advertisement -