Replication - Not defined as a remote server -- sql server replication

george
7/7/2003 10:26:02 AM

From Getting Started TaskPad|Replicate Date|Configure
Replication. Go through the wizard with all the defaults.
Click Finish. Gives the error: "SQL Server Enterprise
Manager could not configure 'SQL1' as the Distributor
for 'SQL1'. Error 18482: Could not connect to
server 'SQL2' because 'SQL2' is not defined as a remote
server. Remote logins for remote server 'repl_distributor'
have been dropped. Server dropped. Server added. Server
network name set.".

Background info.
My old server was a Distributor/Publisher with Merge
replication setup to a different server. I made a new and
improved server to be the Distributor/Publisher and use
the old one as the subscriber. So I used the 'Remove
Replication'...removed it completely from the Live
server. Renamed it from SQL1 to SQL3. The new server
from SQL2 to SQL1. Somewhere along the line it has an
orphaned record? Is there a stored procedure I can run to
remove? If I try to click on 'Remove Replication' from
the new server it just gives me the message 'No
Distributor is installed for server 'SQL1'. Maybe delete
from a system table manually?

pheckz NO[at]SPAM hotmail.com
7/9/2003 1:21:05 AM

1. If you are using IP address, create an alias (sql2) from client network utility.
2. make sure that sql2 @@Servername SVRID = 0. Open the sysservers table from
master db for your reference.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Replication - Not defined as a remote server