Tuesday, January 17, 2012

How to Resolve TCP/IP Connection Named Pipe problem in sql server with Windows 7

Note : Some Times when we connect our system Sql server to another sql server then it gives error of Named Pipe as given below:



Solution : Follow given blow steps with screen shots.

My Compuret -> Manage

 All Status should be Enabled accept VIA Protocol

   All Status should be Enabled accept VIA Protocol

Check Properties of TCP/IP  
 TCP/IP Port should be 1433

Now Go To Control Panel and Choose Firewal Option

  Choose Advance Settings Option

Select 
1.  Inbound Rule Option from left and then 
2. Choose New Rule Optioin

 select Port Option
 Choose TCP Option and Enter 1433 port no (Which is Sql server default port No.)
 Choose Next
 Choose Next

Enter Rule Name: Sql then Click Finish
 Now You will find that Rule which You have made will be shown in List. As selected given below:

 Now connect our SQL SERVER 2005 it will definitely connect 

No comments:

Post a Comment