SQL Connection with ASP.net

[Guest]

i have developed a web application for intranet and it is installed on the
Computer name 'Server' and its already installed sql server 2005, never
problem when connecting to sql server 2005 on the 'Server', this intranet has
another computer named 'B' and it's already exist SQL2000. i want update some
data to SQL2005 on 'Server' using in a SQL2000 which have 'B' computer' when
connecting to 'B' it return error like bellow.

'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)'

please help me

 

[Guest]

i already set as the enable of rome connection in SQL Server according to
that error message, using connection object can connect with sqlserver 2005
in the same machine, but when connectiong to another server error msg occure,
pls help me






- Show quoted text -

Have you checked the firewall?

How to configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/kb/914277