Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Replication Error

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-02-26 : 07:53:36
kuruvilla writes "Hi Every body
Hey i have a problem in sql server. I have 2 Databases let for Ex Test1 and Test2. Test1 is Hosted remotely and Test2 is in Local server.
I want to replicate the date from Test1 Database which is hosted remotely to Local Server Test2.This i want to do by using replication feature in SQL server. So what is the procedure to do this.
I have done this replication in2 database wich are present in the same server and
it is working fine but in 2 different servers(Not version of SqlServers.
Two different servers means two different system which are remotely connected)
it is showing some security problems.

The error description as follows.. While verify subscriber.......
Error no1012;

Unable to activate the agent on the specified remote servrt because of security restrication.
use dconmcnfg on the remote server ao allow the local sql server agent to activate the agent
Iam in deadly need of this.
Can any body there help me
Regards
Kuruvilla kuruvilla_ek@yahoo.com"
   

- Advertisement -