Configure Publication error when using remote distributor

Question

hi,all

i have added servername\repl_logreader,servername\repl_snapshot  in sqlserver Logins.. and done everything for creating publications

using remote distributor:

int the last step in Publication wizad,erros happen as follows:

Proxy "servername\repl_logreader" is not a valid Windows user.Changed database context to "publication db"

mark: there is nothing errors when using local distributor

Answer 1

Hi huisky,

i have added servername\repl_logreader,servername\repl_snapshot  in sqlserver Logins???

Logins as one login account name, you can add the name as Administrator, TEST,MIAOYUXI...

Follow the step from the reply in your case :configure-remote-distribution-error

BR,

MIAOYUXI

Answer 2

Hi huisky,

Logins as one login account name, you can add the name as Administrator, TEST,MIAOYUXI...

May I use 'sa' account to login in? both server1 and server2 I login with account 'sa'..

Don't you need a windows account in 'Snapshot Agent Security' Wizard？

Answer 3

i think thers is something wrong in 'Agent Security' Wizard...

case 1: select 'Run under the following Windows account'

errors: Proxy "servername\repl_logreader" is not a valid Windows user.Changed database context to "publication db"

case 2: select 'Run under the SQL Server Agent service account'

i can not start Snapshot Agent and Logreader Agent..

errors: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections

 

Answer 4

Yes.You can.

Answer 5

That is one connectivity error.

1.close the fire wall;

2.Enable TCP/IP protocols both in your server and client side;

3.Use 1433 port;

4.Restart the sql engine service.

troubleshoot-connecting-to-the-sql-server-database-engine

Answer 6

all above tips is done. Not the problem above.

in 'Agent Security' Wizard ->

Can only select the choice 'Run under the SQL Server Agent service account'',when using remote distirbutor ?

It puzzles me..

Answer 7

Yes.

You can choose the option.

Answer 8

thanks for your patience..

I done like this and finished the New Publication Wizard

my publications settings as follows:

but i can not start Snapshot Agent and Log Reader Agent:

need help.. 

Answer 9

my SQL Agent Server account is default:

Answer 10

It doesn't matter.

Answer 11

thanks for your patience..

I done like this and finished the New Publication Wizard

my publications settings as follows:

but i can not start Snapshot Agent and Log Reader Agent:

need help.. 

still failed。。

Answer 12

some detail errors:

Answer 13

Enable THE TCP\IP PROTOCOL both in your DIS and PUB by SSCM and then restart the SQL service.

Answer 14

THE TCP\IP PROTOCOL both is ok.

publication:

distribution:

Answer 15

Can I have a remote for your issue?

Answer 16

Or you can choose to ask professional engineers for help, and they will deal with your problem separately and confidentially:AssistedSupportProducts

Answer 17

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/81a77ecc-29d7-4191-8dc9-8de452a04633/transactional-replication-snapshot-agent-can-not-start-when-using-remote-distributor?forum=sqlreplication#1d9dec47-03ef-4fce-a70d-b54599d6075b  maybe it is helpfull

Answer 18

Or you can choose to ask professional engineers for help, and they will deal with your problem separately and confidentially:AssistedSupportProducts

They can remote with you.

Answer 19

Or you can choose to ask professional engineers for help, and they will deal with your problem separately and confidentially:AssistedSupportProducts

They can remote with you.

       Thanks for your suggestion..

Answer 20

You're welcome.