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 |
|
mcbulan
Starting Member
7 Posts |
 Posted - 2011-06-04 : 18:31:09
|
| Hello all,I am developing a high load web based application with .netI am using MS SQL SERVER 2008 r2 as database. I want to configure the sql server to use different pools/connections for each LAN access users and WAN access users.I mean, when an user accesses to the system inside LAN, MS SQL Server will use a different pool, because there are many local (intranet) users and will use an another pool for all queries for the users come from internet (outside)."Can i" or "how can i" do this in MS SQL Server??Thanks for all help.mcb |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-06-06 : 18:19:37
|
| Are you referring to Connection Pools? If so, why do you care which connection pool is being used?=======================================Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
use differen pools to use for different users