I'm trying to establish a multiprotocol connection from one SQL server to another through a firewall. When I try to create a SQL server registration in enterprise manager I get the following error.
SQL Server registration failed because of the connection failure displayed below. Do you wish to register anyway?
Communication Link Failure.
I can make a registration fine using tcp/ip over port 1433. I can also connect to the server I'm trying to connect to from a different server over multiprotocol so I think I have it narrowed down to something wrong on the computer I'm trying to connect from. I have the client alias set up the same on the one its failing from and the one its working from. Anyone have any thoughts?
SQL Server registration failed because of the connection failure displayed below. Do you wish to register anyway?
Communication Link Failure.
I can make a registration fine using tcp/ip over port 1433. I can also connect to the server I'm trying to connect to from a different server over multiprotocol so I think I have it narrowed down to something wrong on the computer I'm trying to connect from. I have the client alias set up the same on the one its failing from and the one its working from. Anyone have any thoughts?