john230873
Programmer
Setting up a transactional replication on a windows small business 2003 server. I have set this up in the past with Windows 2000 server fine (same database) but this is the first with 2003.
Did everything as normal
eg set up Distribution as normal with all defaults
set up a database as a transactional publisher
When I did this I got an error on the log reader which is an access violation occurred
If I look at the log reader job in the SQL server Agent I can see that the statement that causes the issues is -Publisher [CXDB1] -PublisherDB [pubs] -Distributor [CXDB1] -DistributorSecurityMode 1 -Continuous
I thought it could be the database so I changed the database to test this on the pubs database but I still get the same errors (yes disabled and uninstalled then recreated the Distribution)
I have even changed the path of the Distribution but this still hasn't help.
Service Pack is sp2a
Did everything as normal
eg set up Distribution as normal with all defaults
set up a database as a transactional publisher
When I did this I got an error on the log reader which is an access violation occurred
If I look at the log reader job in the SQL server Agent I can see that the statement that causes the issues is -Publisher [CXDB1] -PublisherDB [pubs] -Distributor [CXDB1] -DistributorSecurityMode 1 -Continuous
I thought it could be the database so I changed the database to test this on the pubs database but I still get the same errors (yes disabled and uninstalled then recreated the Distribution)
I have even changed the path of the Distribution but this still hasn't help.
Service Pack is sp2a
