I have a SQL Server 2000 installed in a P4 2.4GHz server with 20 users connected into it. It there any solution that creating a connection pool for those 20 users connect to SQL server with only 1 connection. Meaning to say, I will build up a agent to get a single connection to the SQL Server and multiple connection from 20 users to the agent.
using this method, how many SQL Server Connectivity licenses required? One or still 20?