After you change the connection settings, new logins use the new settings but current logins are not affected.
For more information on these settings see "user options Option" in Microsoft Books Online.
See Also
SQL Server Properties
SQL Server Properties (General Tab)
SQL Server Properties (Security Tab)
SQL Server Properties (Settings Tab)