| Author |
Topic |
|
chedderslam
Posting Yak Master
223 Posts |
 Posted - 2008-06-24 : 11:15:23
|
| What is the maximum number of connections for sql server developer edition?The "compare editions" on the microsoft site doesn't say. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-06-24 : 12:10:15
|
there shouldn't be any limit afaik - it's basically the enterprise edition with the license requirement that you aren't supposed to put it on a production server. an org is not supposed to make any money with dev editions.
elsasoft.org |
 |
|
|
chedderslam
Posting Yak Master
223 Posts |
Posted - 2008-06-24 : 12:18:01
|
| Thank you for the response.I didn't think there were any limits, but I wanted to make sure. I am trying to implement connection pooling for a web app, but it seems that I can only run one query at a time. Is there anything sql server side that might be causing this? Each of the connections is using the same account log in/password. Can the same credentials create more then one connection at a time? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-24 : 12:50:00
|
| There is nothing on the SQL Server side preventing you from doing this. Yes you can connect multiple times with the same credentials.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
chedderslam
Posting Yak Master
223 Posts |
Posted - 2008-06-24 : 12:52:30
|
| I thought so. So it looks like the problem is in my code. Thank you for the help. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-06-24 : 12:58:32
|
is your db in single user mode?
elsasoft.org |
|
|
|
chedderslam
Posting Yak Master
223 Posts |
Posted - 2008-06-24 : 13:35:44
|
quote:
Originally posted by jezemine
is your db in single user mode?
I don't know. It is a default install of SQL Server Developer Edition. How would I check?Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-24 : 13:37:25
|
| You would be getting an error if your database were in single user mode and the single connection was already taken. By default, this option is not turned on. To see the option, check out the options page of the database properties.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
chedderslam
Posting Yak Master
223 Posts |
Posted - 2008-06-24 : 13:43:30
|
| Under Database Properties > Options > State > Restrict Access, it is set to MULTI_USER. Is this what I want? It looks like it. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
chedderslam
Posting Yak Master
223 Posts |
Posted - 2008-06-24 : 13:54:19
|
| Thank to everyone for the help. Cheers. |
|
|
|
|
number of connections for developer edition?