| Author |
Topic |
|
dejjan
Yak Posting Veteran
99 Posts |
 Posted - 2005-03-07 : 06:11:35
|
| Hello,I have merge replication .. and I want to change 'sa' password on the Subscriber. When I do that, my replication stoped. Message is:"The process could not connect to Subscriber 'SubscriberName'".The server is linked with same login - 'sign'. After I changed password I could connect by Query Analizer (or Enterprise Manager) with login 'sign', but replication doesn't work.What's going on? And how to solve this problem ?Thanks for any help |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-07 : 15:44:27
|
| So have you tried recreating replication?Tara |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-03-08 : 02:50:03
|
| you go to EM, tools, configure publication,subscribers and distributionsubscriber tabchange the password--------------------keeping it simple... |
|
|
|
dejjan
Yak Posting Veteran
99 Posts |
Posted - 2005-03-08 : 03:33:18
|
| Jen, are you sure that is the way to change password on the Subscriber.First question, when I start EM\Tools\Configure publication, subscribers and distribution\ , is to select Distributor, which I already have (Publisher and Distributor on the same machine). Then to specify root location for snapshots from Publishers that use Distributor, and so on. There isn't Subscriber tab.I have 15 Subscribers, and I want to change theirs passwords. I would like not to recreating replication because snapshot replication is about 4 hours long.When I changed password on the Publisher it wasn't hurt. I didn't have any problem. Replications proceed without problem.But when I changed password on the Subscriber side, I have a problem.One question more,could I recreate replication without snapshot. How it works.Thanks for help |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-03-08 : 04:15:40
|
| you should be able to see the 4 tabs, one of which is subscribers...if you changed the sa password on the subscriber side, and this caused the problem, just change the password on the tab i mentioned above.yes, you can have replication without starting snapshot, it's one of the options during setup, if you recreate the publicationwhat exactly is the error message? is it distributor or subscriber side?--------------------keeping it simple... |
|
|
|
dejjan
Yak Posting Veteran
99 Posts |
Posted - 2005-03-08 : 04:48:17
|
| I am so ... I started "EM\Tools\Configure publication, subscribers and distribution\ " on the Subscriber side, and I run wizard for creating Distributors and Publisher.Yes I have this 4 tabs. And it works.Than you a lot. I am new in this area so, I don't know much.When you said - to recreate replication, do you mean to delete every subscriber in EM\ServerName\Replication\Publications, and to recreate them all, or there is some other way to do this. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-03-08 : 05:00:32
|
yes, to recreate a publication, you have to drop all of the subscriptions to it. it's pretty tedious but i haven't tried any other way yet, maybe someone here knows a shorter way...  the shortest way to modify a publication is to go to it's properties and make the changes there, depending on what you need to do--------------------keeping it simple... |
|
|
|
dejjan
Yak Posting Veteran
99 Posts |
Posted - 2005-03-08 : 05:22:14
|
| If I want to add new Subscriber, it would be much easier for me to do restore of last full backup and then to include it in replication. It is easier and faster, in my environment, then to do snapshot replication.I am sure it could be done. But I don't know how. This is the last question ... I promise ... for now. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2005-03-24 : 09:51:53
|
quote:
Originally posted by dejjan
One question more,could I recreate replication without snapshot. How it works.
Creating replication without snapshot is not possible.If the table is already in replication then altering the table schema does not require a snapshot. But if you are adding a new table then snap shot creation is must. Eventhough the snapshot is created for all the articles only the definitions regarding the new tables will be transfered to the subscriber.Regarding your problem with pulling subscription, ..one more way to rectify it is to ...from SERVICES->sql servver agent-> and change the pwd at logon account..this should solve your problem...------------------------I think, therefore I am |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-03-28 : 01:12:58
|
quote:
Originally posted by dejjan
If I want to add new Subscriber, it would be much easier for me to do restore of last full backup and then to include it in replication. It is easier and faster, in my environment, then to do snapshot replication.I am sure it could be done. But I don't know how. This is the last question ... I promise ... for now.
you need to run the snapshot atleast once to synchronize the publisher and subscriber's data and table schema.replication creates an additional column to monitor the changes made on the source in order to reflect it on the destination. And snapshot will do this for you. Though I haven't tried creating the column "manually", if you do try, please share what you've learned  --------------------keeping it simple... |
|
|
|
|
New 'sa' password in Merge replication