How can I configure SQL server Replication

Question

Post reply

How can I configure SQL server Replication

chaminda 23703

SSC Journeyman

Points: 90
More actions
June 27, 2016 at 10:24 pm

#319596

I need to configure sql server peer to peer replication between local computer and remote server. I can't do it. Please help me......

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

durga.palepu Hall of Fame Points: 3530 More actions · Answer 1

Let us know the work you have already completed and where exactly you've struck so that we can help you.

chaminda 23703 SSC Journeyman Points: 90 More actions · Answer 2

One issue is after I connect remote sql server , green arrow not show. Is it problem to replication ?

durga.palepu Hall of Fame Points: 3530 More actions · Answer 3

please share the error description and screenshot(s).

chaminda 23703 SSC Journeyman Points: 90 More actions · Answer 4

chaminda 23703

SSC Journeyman

Points: 90

June 28, 2016 at 12:24 am

#1887173

please see the attachment

durga.palepu Hall of Fame Points: 3530 More actions · Answer 5

Please check the SQLAgent whether its running or not on the server.

If its running, then it seems the required replication job is already running from previous execution ; restart it and check.

chaminda 23703 SSC Journeyman Points: 90 More actions · Answer 6

Sql server Agent Ran, but green Arrow missing on Remoter sql server

chaminda 23703 SSC Journeyman Points: 90 More actions · Answer 7

please see the attach file. VM1 server running with out green arrow. Is it issue for replication ?

durga.palepu Hall of Fame Points: 3530 More actions · Answer 8

I believe its not a replication issue.

Please check with your admin team to investigate the issue with this VM.

chaminda 23703 SSC Journeyman Points: 90 More actions · Answer 9

please tell me why green arrow missing ? and how solve it ? This issue I can see after connect remote sql server....

ankur_libra Hall of Fame Points: 3999 More actions · Answer 10

Hi,

When a user have permissions to do RDC (remote desktop connection) to a physical/virtual server, only then the green arrow is shown else not.

Showing Blank means you do not have permissions to 'Log On' on those servers.

Regards,

Ankur

chaminda 23703 SSC Journeyman Points: 90 More actions · Answer 11

I can access remote sql server from my SSMS. But its green arrow missing. So I can't use peer to peer transnational replication between my local computer and remote server.

chaminda 23703 SSC Journeyman Points: 90 More actions · Answer 12

please see the attachment. It occur when I enable peer to peer subscription. what is the error ?

durga.palepu Hall of Fame Points: 3530 More actions · Answer 13

You are missing the point.

Its not about connecting from SSMS but connecting using RDP(Remote Desktop); You can access this using MSTSC command in RUN in windows.