Hey all...

We have several websites running SQL server back ends and we have
successful registrations for each in SQL Servers Enterprise Manager.

We also have a client who hosts their own SQL Server Database and we
used to have a good registration for their SQL Server.
Our client has moved their website and SQL Server to a new server as
the machine they were running on had an unknown fault, and since they
have moved everything we can no longer see the database or register
the server in Enterprise Manager.

We can still register servers from other clients and the client we are
having trouble with can register their server using standard dial up
connections and the admin guy did it from his cable modem account from
home. We have tried using the VPN tunnel they prepared for us as well
as trying to register after they put the server outside the firewall.
The only firewall changes that were made wer after our first being
unable to connect, then they allowed all traffic from our IP in.

To summerize, They can register SQL Server externally (from home etc)
and we cannot, but we can register all other SQL Servers except
theirs.

What error do you get when you try to connect?

Rand
This posting is provided "as is" with no warranties and confers no rights.

The error dialog reads:
==========
SQL Server registration failed because of the connection failure
displayed below. Do you wish to register anyway?

SQL Server does not exist or access denied
ConnectionOpen(Connect())
==========

I think it may be some sort of firewall problem, but they assure us
that the server has been placed outside their firewall during some
attempts to connect and our firewall is definately working OK as we
can connect to other, ISP hosted SQL Servers.


[quoted text, click to view]