I'd guess the Enterprise Manager is trying to access the SQL Server via named pipes rather than TCP/IP.
Start menu, Programs, Microsoft SQLServer 7, Client Network Utility
In the General Tab, you can either select TCP/IP as the default network library (but your other registered SQLServer might stop working), or you can add a record for that server and specify to use TCP/IP.
Hope this helps!
>Hi, all!
>
>We are having some problems connecting to a remote SQL-Server.
>
>When we try to register the Remote SQL-Server, we get the following message:
>
>
>SQL Server registration failed because of the connection failure displayed below. Do you wish to register anyway?
>
>Specified SQL Server not found.
>ConnectionOpen (CreateFile())
>
>
>If we press "yes", it still fails.
>
>Anyone out there have any ideas that may help us? Are we even doing the right thing?
Sylvain Demers