Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is NT Workstation a feasible SQL Server 11.x platform?

April 26, 2017feasible NT Platform SQL Server Workstation

0

Posted

Is NT Workstation a feasible SQL Server 11.x platform?

1 Answer

0

Posted

Yes. At one time, Microsoft set a limit on the number of incoming sockets available on a 4.0 NT workstation, enforcing this limit in the NT registry. Consequently, SQL Servers running on a 4.0 NT workstation could communicate via client-side socket to no more than 10 clients at a time. This made the 4.0 NT workstation a poor choice for a SQL Server platform. Microsoft has since disabled the enforcement program. However, Microsoft’s license agreement specifies the socket limit.