Hello there

I've got this error when i tried to connect sql server from biztalk on
another domain:

provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server

where can be the problem?

Roy,

This error is just saying "could not connect", so you are having a problem
reaching the other server. The "Named Pipes" is not a clue, just an artifact
of how the connection is attempted. You will need to figure out what
authentication problem is preventing you from communicating to the server on
the other domain.

-- Details on the error message --

If you look at your network configuration, you will probably see that Named
Pipes is the last provider that your connection will try. Look at SQL
Server Configuration Manager \ SQL Native Client Configuration. My order is:
Shared Memory (1), TCP/IP (2), Named Pipes (3).

So, the connection tries Shared Memory (which does not work), TCP/IP (which
does not work), and Named Pipes (which also does not work), then issues the
message which seems to blame named pipes. (If you change the order to put
TCP/IP last, you will get the error message that seems to blame TCP/IP.)

RLF
[quoted text, click to view]