Posted by Erland Sommarskog on 08/04/06 22:01

RAM (r_ahimsa_m@poczta.onet.pl) writes:
> Could you help me please to solve the prblem with connecting to SQL Server
> from .NET development environment?
> I have the following error:
>
> "An error has occured 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 setting SQL Server does not allow remote
> connections. (provider: Named Pipes Provider, error: 40 - Could nott
> open a connection to SQL Server)
>
> Please help. I changed option for remote connections but it doesn't help.

Does the server accept connection from Named Pipes? Check this in
the SQL Server Configuration Manager.

Have you tried to connect over TCP/IP.

Also check firewalls etc.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]