caching

Question

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
how to ectify the problem.

Niradhip Chakraborty · Answer

Try this:
Select sql server 2005 Go to configuration tool, select sql server surface area configuration.
Next select surface area configuration for srvices and connections.Then select remote connections.
Under remote connections select local and remote connections option and finally select using both TCP\Ip and named pipes

Arshad · Answer

Hi, I think you are trying to open the Connection in the with the Local Network. That system you are trying to connect, just check that TCPIP of that System. I think that is off, just enable that, Thanks