Note that the MaxUserPort and TcpTimedWaitDelay settings are applicable only for a client computer that is rapidly opening and closing connections to a remote computer that is running SQL Server and that is not using connection pooling. Adjust the MaxUserPort and TcpTimedWaitDelay settings The issues appears to be that the web server was running out of dynamic ports due to the large volume of individual connections to the SQL server. Each iteration in the master batch upload process contained approximately 50+ individual SQL transactions. This error was encountered on a web application running a batch upload of records into a SQL server database.
(provider: TCP Provider, error: 0 - Only one usage of each socket address (protocol/network address/port) is normally permitted.) Verify that the instance name is correct and that SQL Server is configured to allow remote connections. The server was not found or was not accessible. Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server.
