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

Remote Connection Expand / Collapse
Author
Message
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

-------------------------------------------
Cheers,
Sur...
'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: Monday, August 18, 2014 7:16 AM
Points: 257, Visits: 174
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: 2 days ago @ 8:57 AM
Points: 6,634, Visits: 1,872
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), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #425321
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse