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.
| Author |
Topic |
|
BigRetina
Posting Yak Master
144 Posts |
 Posted - 2003-01-22 : 07:50:13
|
| Salute.I have SQL Server 2000 with Per Seat Licensing Mode set to 20 devices.However, Using my VB.NET app I performing a test loop that creates 50 SQL Connections and they are all connecting successfully!...How can that be possible?..shouldnt it throw an exception or error after the 20th connection?..Maximum Concurrent User connection in the Server Properties ( in the EM ) is set to 0 which is unlimited!..are the "devices" in the licensing applet in control panel and user connection in the EM same thing?Thanks In Advance.p.s. I didnt know where to exactly post this one in development tools or here..but i thought that it is mostly a licensing question so here it goes!. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-22 : 08:54:42
|
| The license covers 20 DISTINCT client computers that can connect. Each computer can have any number of connections to the SQL Server, they are still being made from one client. If you ran your test from a single machine then you can open hundreds of connections without violating the license.I wouldn't worry too much about the license restrictions. The server will send a pretty clear message when the 21st computer attempts to connect. |
 |
|
|
|
|
|
Licenses and Connections