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 |
|
rajesha
Starting Member
36 Posts |
 Posted - 2002-06-14 : 03:56:04
|
| i done one transactional replication for a database (db1)from server1 to server2.after creation of publisher for db1 i pushed the same to server2.at last a pop up window of sql server enterprise manager come.and it is showing the following error.subscriptions were created successfully at the following subscribersserver2sql server enter prise manager couldnt start the service.'sql server agent' on server server15- access is deniedthe subscription at subscriber server2 cannot be initialized immediately.because the snapshot for this publication is not available .to initialize the subscriptionstart the distribution agent after the snap shot is available.can any body tell me what is the problem |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-06-14 : 04:03:36
|
| Sounds like your SQL Server Agent on server2 hasn't been set up with enough permissions... Can you give info on what account it is running under? e.g. Local or domain, if any restrictions have been imposed by the Admin etc...PeaceRick |
 |
|
|
rajesha
Starting Member
36 Posts |
Posted - 2002-06-14 : 04:40:07
|
| it is running under one domain account.there is no restrictions in admins...can you tell me where i have to check this more perfectly.my server is sql2000 |
|
|
|
rajesha
Starting Member
36 Posts |
Posted - 2002-06-14 : 06:23:18
|
| i solved the first problem.but now when am pushing it is showing...subscriptions were created successfully at the following subscribersserver2the subscription at subscriber server2 cannot be initialized immediately.because the snapshot for this publication is not available .to initialize the subscription start the distribution agent after the snap shot is available.what is the problem? |
|
|
|
|
|
|
error in replication