Replication

i'm running 2 sql servers

server1 = (sql2000 8.0.2194)

server2 = (sql 2005 9.0.5000)

server1 publisher , server2 distributor , subscriber

for reason managed create server1 , publisher on server2 can seem sonfigure server2 distributor on server1 see error below

error 18483: not connect server xxxx because
'distributor_admin' not defined remote login @ server

 

what cause?

thanks lot

best regards,

vusi radebe

try on problem server:

 

use master
go
select @@servername

this should return current server name if returns null try:

use master
go
exec sp_dropserver 'oldname'
go
use master
go
exec sp_addserver 'newname', 'local'
go

---

looking book on sql server 2008 administration? http://www.amazon.com/microsoft-server-2008-management-administration/dp/067233044x looking book on sql server 2008 full-text search? http://www.amazon.com/pro-full-text-search-server-2008/dp/1430215941

SQL Server  >  SQL Server Replication