Ping,
possibly this is a reference to a name change carried out on your subscriber
server.
Do
select @@SERVERNAME
select SERVERPROPERTY('ServerName')
return the same value or different values?
Regards,
Paul Ibison

Ping,
running this should fix the issue:

Use Master
go
Sp_DropServer 'Server1'
GO
Use Master
go
Sp_Addserver 'Server1', 'local'
GO
Stop and Start SQL Services

Regards,
Paul Ibison

[quoted text, click to view]

Hi dear Paul I have such problem

I use this
Do
select @@SERVERNAME
select SERVERPROPERTY('ServerName')

and first line respond Null and secound respond VOIP_SQL_SERVER

[quoted text, click to view]

Use Master
go
Sp_DropServer 'VOIP_SQL_SERVER'
GO
Use Master
go
Sp_Addserver 'VOIP_SQL_SERVER', 'local'
GO

but the response was :
Server: Msg 15028, Level 16, State 1, Procedure sp_addserver, Line 14
The server 'VOIP_SQL_SERVER' already exists.


I have another problem. I dont have any replication setting on thi
server but when I want to set one it says: Couldn't set replicatio
cause one or more databases sets to replicate.

please help me it's realy urgent


-
ssa135
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message693652.htm

After you run
Sp_DropServer 'VOIP_SQL_SERVER'
GO
is there any error message? If not, then if you query sysservers do you see
this server?
I haven't tested this but perhaps it may be configured in there as a
remote/linked server and so still exist. If the record is still in
sysservers then have a look at your linked servers and remote servers under
security and remove it if it is there. Querying sysservers should at this
stage show there is no server called 'VOIP_SQL_SERVER' and then you can add
it as your local server.
HTH,
Paul Ibison