Replication problems

Hi group
I have the following setup:
A primary sqlserver running windows 2000 server OS
a secondary sqlserver running windows 2003 server OS
Both sqlservers run sqlserver 2000 software, and both logon with the
local administrator account. Both administrator account have the same
password, so accessing \\<servername>\c$\....\repldata shouldnt be a
problem.
the primary sqlserver has been configured as the publication server,
publicating a database called repli_test, as snapshot
The secondary sqlserver has a pull subscription to the repli_test
database.
When I try to pull the database, I get the following error:
The job failed. Unable to determine if the owner
(SQL-BACKUP\Administrator) of job
SQLSERVER-repli_test-repli_test-SQL-BACKUP-repli_test-9DA1AF79-158C-49BD-89B6-64D8F9EF2C21
has server access
(reason: Could not obtain information about Windows NT group/user
'SQL-BACKUP\Administrator'. [SQLSTATE 42000] (Error 8198)).
any suggestions to a solution?
TIA
Kaare
Try changing the job owner to sa.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thank you very much for your reply. It really did the trick.
Unfortunally Im stock on another problem. Replication doesnt seem to
work, if a table contains more than 255 columns. Is there any workaround
on this issue?
TIA
Kaare
|||The main advised workaround is to partition the table and then replicate as
two articles in the same publication. From the point of view of the system,
this could be made transparent as you could have a view which unions the
data from the 2 tables, and call the view the same as the curent table. This
would be taking advantage of non-distributed partitioned views.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)