problem with asp.net2.0/sqlserver200

[S Bhushan]

Hi Guys I am facing problem while connecting asp.net 2.0 program to sqlserver 2000 database. database is on remote machine. error is.. 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) It is working perfectly in local system Regards Shanti Bhushan

[Mike Ellison]

Does this article help? http://www.cryer.co.uk/brian/sqlserver/hresult_0x2%20npp_error_establishing_connection.htm[^]