remote connections

how can I check if ' remote connections' is enabled in sql 2008.. i ran a bcp command and getting this:
if it is not, then i want to enable it.
-----------------------------

SQLState = 08001, NativeError = 53
Error = [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could no
t open a connection to SQL Server [53].
SQLState = 08001, NativeError = 53
Error = [Microsoft][SQL Server Native Client 10.0]A network-related or instance-
specific error has occurred while establishing a connection to SQL Server. Serve
r is not found or not accessible. Check if instance name is correct and if SQL S
erver is configured to allow remote connections. For more information see SQL Se
rver Books Online.
SQLState = S1T00, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Login timeout expired
LVL 5
25112Asked:
Who is Participating?
 
dqmqCommented:
Use surface area configuration utility:  Connections tab.


Use configuration manager utility: Network Configuation tab


Use Management Studio:  Server Properties: Connection Properties tab
0
 
MuffyBunnyCommented:
0
 
dqmqCommented:
Screenshot of above utilities
ee.bmp
0
 
25112Author Commented:
thanks - I did it from SSMS..

is it one of the options in http://msdn.microsoft.com/en-us/library/ms189631.aspx ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.