Hi

I have two SQL Servers (6.5). One based in London (LDNINNTS9) and one in New York (NYINNTS2).

I had bidirectional replication set up on one table in a DB and everything is (WAS!!!) working fine. Came to work this morning (Monday typical!) and the following has happened.

When I select the remote servers option on the NY server from Enterprise manager I get the following error message

Unable to connect to site '0'because '' is not defined as a remote server.

Now it says that '' is not defined as a remote server. So I did a select of @@Servername and it has returned (null). It was set to NYINNTS2. I have tried executing some ISQL to change the name and started and stopped the SQL Services but the name remains (null). Does anyone have an idea of what I can do to set the name up as it was?

I know that the Server name gets set to null if it is invalid, but I am trying to set it to NYINNTS2, which should not be invalid? Does the domain name impact the validity of the name?

HELP!!!!


Regards

Steve Farmer