How many concurrent we can have in SQL Server 2005 Express?
-
Hi, How many concurrent we can have in SQL Server 2005 Express? Does it make difference with the operating system like windows server 2003/2008 or winxp pro? And I am getting error while connecting to the sql server 2005 express that the remote server has refused the remote connection (Error no. 26) though it was working fine before couple of days (I have enabled the remote connection via/pipeline/tcpip and also added in firewall exception port 1433. It was working fine before). After that I have just restarted my server and its works fine! What can be wrong in this? May be the number of concurrent connection has reached! Thanks, Divyesh
-
Hi, How many concurrent we can have in SQL Server 2005 Express? Does it make difference with the operating system like windows server 2003/2008 or winxp pro? And I am getting error while connecting to the sql server 2005 express that the remote server has refused the remote connection (Error no. 26) though it was working fine before couple of days (I have enabled the remote connection via/pipeline/tcpip and also added in firewall exception port 1433. It was working fine before). After that I have just restarted my server and its works fine! What can be wrong in this? May be the number of concurrent connection has reached! Thanks, Divyesh
I don't see a connection limitation in SQL server express, but there are indeed tcp connection limitations in windows XP. (Microsoft wants you to buy the server if you're doing server work).
-
I don't see a connection limitation in SQL server express, but there are indeed tcp connection limitations in windows XP. (Microsoft wants you to buy the server if you're doing server work).
-
No, not really. This was introduced to limit the number of half-open connections (typically session in the SYN_WAIT state). A number of worms were rampant at that time, and they opened oodles of connections to systems simultaneously. P2P systems typically do likewise, so this patch was developed to allow P2P to run. I doubt that this is the OP's problem. I was thinking more in the line of this[^], but MS seems to imply that they don't enforce the inbound connection limit, except for SMB operations. So if the SQL server is connecting though named pipes, yes it would be a problem, but normal TCP connections should be okay.