how will webserver running IIS 5.0 handle multiple dbserver connections?

one websevers one website one page,

three users clients

two dbservers different databases on each using sql server 2005 server express

when any of the client accessing the page from his computer clicks on

button A ---- connect to 'table1' of db 'first' on dbserver1
button B ---- connect to 'table1' of db 'second' on dbsever2

question is in my experience with vs08 coding, when one connection is opened, another attempt to open an connection is refused, saying an connection is already there which needs to be closed first.

so how will the webserver IIS 5.0 handle this, allow a connection at a time?

i think my question is not clear

for answerers:--

yes sql server allows multiple connections

but there are two sql servers running on two different computers.

Answers


your sql server should easily allow multiple connections without issue. It has nothing to do with IIS


Need Your Help

Does Java synchronized keyword flush the cache?

java volatile synchronized double-checked-locking

Java 5 and above only. Assume a multiprocessor shared-memory computer (you're probably using one right now).

PyInstaller --onefile throws Qt error with pandas, matplotlib and sklearn

matplotlib pandas pyqt4 scikit-learn pyinstaller

Using PyInstaller with the --onefile flag, I can successfully build the following script into a .exe: