| Author |
Topic |
|
ashwini28
Starting Member
3 Posts |
 Posted - 2009-01-25 : 11:19:14
|
| Hi Guys,I am doing transactional replication.I sucessfully configured distributor and after that I configured publisher.After configuring publisher...I used launch replication monitor.In replication monitor, I got error login failed for sql server agent.Please guide me...how should I proceed inorder to do transactional replication. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-01-25 : 12:09:00
|
| After you configure Publisher, you need to add subscriber.Make sure the accounts you are using when configurring the distributor, actually have access to the publisher and subscriber. Try logging in with those accounts in SSMS/Query Analyzer to check if the login works.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
ashwini28
Starting Member
3 Posts |
Posted - 2009-01-25 : 21:28:50
|
| I know I have to configure subscriber also.But after configuring the publisher...when I check whether it is configured properly by launching replication monitor I am getting an error. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-27 : 07:29:54
|
| Configure Subscribers also and check in Repl monitor. |
|
|
|
Liew2020
Starting Member
26 Posts |
Posted - 2009-03-03 : 00:28:59
|
quote:
Originally posted by dinakar
After you configure Publisher, you need to add subscriber.Make sure the accounts you are using when configurring the distributor, actually have access to the publisher and subscriber. Try logging in with those accounts in SSMS/Query Analyzer to check if the login works.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/
May i know which logging we need to take note while configure Publisher and Subscribe? Can explain in detail?I face the same problem also, and I have no idea which login name I need to change or use.Kindly advice. Thank You.Regards,Jimmy Liew |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-03-03 : 12:43:09
|
| in books on line, under repication check out security considerations for replication - ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rpldata9/html/310a8203-c0aa-4794-93fe-737d7c3fcfd6.htmDinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-03-03 : 14:40:48
|
| WOOOW books online rocks... it seems all over the place. |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-03-03 : 14:58:45
|
| Ashwini, You're getting "Login failed for user error" This doesn't seem to be complete error message. If you are looking for accurate solutions. Please post complete error messsage. And don't forget to check sys.servers system tables output on Publisher to verify setup. You will see is_publisher,is_subscriber,is_distributor entries as 1 if things are set up properly. |
|
|
|
Liew2020
Starting Member
26 Posts |
Posted - 2009-03-09 : 04:48:33
|
| Ashwini, I think you need to first set up a DOMAIN login, and grant appropriate access for both, subscriber and publisher, to access to the snap shot folder. If you missed out this part, before that you must share a folder, and grant access to the domain login (usually use Windows NT login).good luck.Regards,Jimmy Liew |
|
|
|
Liew2020
Starting Member
26 Posts |
Posted - 2009-03-09 : 04:50:18
|
| Ashwini, I think you need to first set up a DOMAIN login, and grant appropriate access for both, subscriber and publisher, to access to the snap shot folder. If you missed out this part, before that you must share a folder, and grant access to the domain login (usually use Windows NT login).good luck.Regards,Jimmy Liew |
|
|
|
|
Transactional replication