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.
| 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 agentIam in deadly need of this. Can any body there help me Regards Kuruvilla kuruvilla_ek@yahoo.com" |
|
|
|
|
|