> HI I set up two remote sql2k5 server, one uses windows 2003 server
> standard, one uses windows 2003 server R2.
>
> i stalled sql2k5 on both server the same way (both has sql2k5 sp1).
> i can't connect to server 1, but not server 2 (see error below).
>
> i checked the sql2k5 server configurations and network protocal (tcp/ip
> is enabled).  they are set up the same.
> but i can only connect to 2nd server locally (when i'm on the server
> directly), but not thru client remotely. what can it be the problem?
>
> can someone help?
>
> TITLE: Connect to Server
> ------------------------------
>
> Cannot connect to ...server IP
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> 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) (Microsoft SQL Server, Error: 53)
>