Remote Access column value is not changing

• G Sunny

  SSC Eights!

  Points: 988

  More actions

  May 25, 2018 at 8:12 am

  #412880

  I ran below TSQL to stop remote connections,

  EXEC sp_configure 'show advanced',1
  go
  RECONFIGURE
  go
  EXEC sp_configure 'remote access', 0
  go
  RECONFIGURE WITH OVERRIDE

  I ran below SQL to see the changes, the value_in_use column is not changes to 0 it still showing 1, I restarted SQL services after running sp_configure, can some one help me why its not changing the value.

     SELECT name, 
  CAST(value as int) as value_configured, 
  CAST(value_in_use as int) as value_in_use 
  FROM sys.configurations 
  WHERE name = 'Remote access'; 

  Thanks

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  May 29, 2018 at 5:42 pm

  #1992246

  G Sunny - Friday, May 25, 2018 8:12 AM

  I ran below TSQL to stop remote connections,

  EXEC sp_configure 'show advanced',1
  go
  RECONFIGURE
  go
  EXEC sp_configure 'remote access', 0
  go
  RECONFIGURE WITH OVERRIDE

  I ran below SQL to see the changes, the value_in_use column is not changes to 0 it still showing 1, I restarted SQL services after running sp_configure, can some one help me why its not changing the value.

     SELECT name, 
  CAST(value as int) as value_configured, 
  CAST(value_in_use as int) as value_in_use 
  FROM sys.configurations 
  WHERE name = 'Remote access'; 

  Thanks

  Is it showing as 0 for configured and 1 in use?  If not and both are 1, try rerunning your sp_configure scripts and check the values in sys.configurations to make sure it's showing 0 configured and 1 in use. And then restart.
  Did you verify the instance was restarted and check for any errors in the log? That change does require a restart of SQL Server but it should have changed after the restart.

  Sue