question

luggg avatar image
luggg asked

What is a distributor?

I tried to run distribution agent from command prompt, it is the format C:>distrib -Publisher [HOMSAR\WULU2012] -PublisherDB [SVRIADX_C2CSearch] -Subscriber [HOMSAR\WULU2012] -SubscriberDB [subs_coredb_dx] -Distributor HOMSAR -DistributorLogin homsar\repl_distribution -DistributorPassword abc!@# Got error: 2013-09-24 03:40:28.751 Connecting to Distributor 'HOMSAR' 2013-09-24 03:40:46.342 Agent message code 20084. The process could not connect to Distributor 'HOMSAR'. Here I am not sure about some of the parameters: -Distributor - What is the Distributor here, is it the distribution database? the SQL Server instance where the distribution database is on, or the host where the distribution agent is started? -DistributorLogin - not sure what is the Distributor, this parameter is uncertain -DistributorPassword - not sure what is the Distributor, this parameter is uncertain Thanks.
replication
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
KenJ avatar image
KenJ answered
"-Distributor" is the instance name that hosts the distribution database. If you have it all on one machine, it will probably be [HOMSARWULU2012]. "-DistributorLogin" and "-DistributorPassword" are for connecting with SQL Server authentication. If you are using Windows authentication you shouldn't need these paramters. You would probably use "-DistributorSecurityMode 1" instead . There are a few sample commands using distrib here - [ http://technet.microsoft.com/en-us/library/ms147886.aspx][1] All of the parameters for distrib are documented here - [ http://technet.microsoft.com/en-us/library/ms147328(v=SQL.100).aspx][2] [1]: http://technet.microsoft.com/en-us/library/ms147886.aspx [2]: http://technet.microsoft.com/en-us/library/ms147328(v=SQL.100).aspx
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

luggg avatar image luggg commented ·
Thanks KenJ, This make it works.
0 Likes 0 ·
KenJ avatar image KenJ commented ·
Glad to help!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.