ekrem_Önsoy

Something pulls you back from changing it but I can't figure out what it is
from this message unfortunately

You can clear the Application Log from Event Viewer. Go to Event Viewer and
right click on it and clear it. If you need to keep that log, then save it
before clearing.

I could suggest you to connect to your SQL Server in a Single-User mode and
then try that change in that mode.

You can do that going to SQL Server Configuration Manager and go to
properties of SQL Server service. Go to Advanced tab and add "-m;" parameter
to the Startup Parameters. Restart your SQL Server service and then try
changing Maximum concurrent connections value.

After performing this, do not forget to going back to SQL Server service
properties and erasing that "-m" parameter and restarting your SQL Server
service. Otherwise, nobody except for you could loging to SQL Server.

Also, stop SQL Server agent before trying to login to SQL Server when it's
in Single User mode, because it may try to use that Single-User right and
then you may end up failing to login to SQL Server because of SQL Server
Agent service.

Please let me know about the result of this process if you proceed.

--
Ekrem Önsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT