Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

disable remote access Expand / Collapse
Author
Message
Posted Tuesday, July 17, 2012 8:53 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, November 9, 2014 5:40 AM
Points: 114, Visits: 998
I am trying to disable remote access for a SQL instance

Here is what I did in SSMS,
Right click server instance-> click properties -> connections (server properties)-> unchecked "Allow remote connections to this server"

Then I restarted sql service

But still I am able to connect from my local machine

Do I miss something?
Post #1330807
Posted Tuesday, July 17, 2012 9:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, November 9, 2014 5:40 AM
Points: 114, Visits: 998
Ok, instead of "restart" I "stopped" and then "started" sql service
and now I am not able to connect from my local machine.

Not sure about diffrence between "restart" and "Stop + Start"

Post #1330812
Posted Tuesday, July 17, 2012 10:22 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:32 AM
Points: 7,135, Visits: 12,745
Daxesh Patel (7/17/2012)
Ok, instead of "restart" I "stopped" and then "started" sql service
and now I am not able to connect from my local machine.

Not sure about diffrence between "restart" and "Stop + Start"


There should be no difference. The "Restart" button in the SQL Configuration Manager and Services MMC is just a GUI feature that does a "Stop" service operation immediately followed by a "Start" service operation.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1330873
Posted Thursday, April 25, 2013 9:29 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 9:31 AM
Points: 56, Visits: 119
I've seen the same myself - after the restart I checked the "running values" for the config as well and that showed "Allow Remote Connections" as unchecked. I still have no idea what happened
Post #1446569
Posted Thursday, April 25, 2013 10:12 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 1:57 AM
Points: 1,323, Visits: 1,156
Disable TCP/IP in SQL Server configuration manager?
Post #1446602
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse