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: Monday, March 17, 2014 7:43 AM
Points: 114, Visits: 985
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: Monday, March 17, 2014 7:43 AM
Points: 114, Visits: 985
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: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
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: Thursday, December 12, 2013 2:47 AM
Points: 56, Visits: 112
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: Wednesday, April 16, 2014 7:10 AM
Points: 1,055, Visits: 711
Disable TCP/IP in SQL Server configuration manager?
Post #1446602
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse