Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Remote Connection Expand / Collapse
Posted Wednesday, November 21, 2007 10:35 PM

Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 25, 2009 5:38 AM
Points: 315, Visits: 49
Comments posted to this topic are about the item Remote Connection

'The bend in the road is not the end of the road Unless u refuse to take the turn"
Post #424818
Posted Thursday, November 22, 2007 9:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 2, 2015 2:50 PM
Points: 257, Visits: 184
Technically, there are 2 right answers to this question.

The SAC tool allows you to enable remote connections by enabling TCP/IP or Named Pipes, or both. However, the SQL Configuration Manager also allows you to turn on these protocols which will also, in turn, allow for remote connections.
Post #425030
Posted Friday, November 23, 2007 10:01 AM

Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Wednesday, June 1, 2016 7:28 AM
Points: 6,637, Visits: 1,904
Yup, and if you ask me which tool *I* am going to use, I'm not going to use SAC because the only thing I'm concerned about is getting the Netlibs enabled, so I'm going to use configuration manager.

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security),
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #425321
Posted Tuesday, October 7, 2014 7:04 AM


Group: General Forum Members
Last Login: Yesterday @ 5:26 AM
Points: 7,969, Visits: 785
Thanks for the question.
Post #1623358
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse