Maximum Connection Limit

The Maximum Connection Limit Has Been Reached

This article refers to any weird cases and in this case it’s making a Linked Server Connection to DB2.

To make nice with SQL run these steps.

  1. sp_configure 'user connections', 0 GO
  2. reconfigure with override
  3. Go to services and restart SQL Server

Now when you need to make or test the connection, it should work.