Thanks Sue,

It is a default instance however but the port is not a default port.

Yes, i used the alias to resolve the connection from the publisher to the distributor and...

Dear Mike / Sue,

I apologise I didnt come back early, I was actually simulating base on Sue's advise.

I started from the basics to see what might be wrong, so we...

Dear Sue,

Thanks for your response.

The configuration "remote proc trans = 0"  was ran on both distribution and Publisher server. However, i did not run the process as 'sa' user but...

Thanks,

The timezone is GMT+1 and the transaction was recent as at the time i did the opentran.

Just to mention the Publisher DB where I am trying to create the publication...

Dear Mike,

Thanks for your response.

This is a Production environment and transactions are constantly coming in. I can also see some open transaction

Transaction information for database ' '.

Oldest active transaction:

SPID (server...

Hello All,

Please, does anyone have suggestion

Thanks Mike

The error showed again while running sp_addpublication.

Pls see error and script below:

Msg 3933, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 1401

Cannot promote the transaction to a distributed transaction because...

Thanks Mike,

We are not using Availability Group.

And also, we are on SQL Server 2014 Service Pack 2

I found this error in the DR log 

2017-10-17 15:26:52.92 Logon   Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030c) 0x8009030c(The logon attempt failed). State...

Thanks for your response.

Yes, the end point are started and I can connect to the DR instance from Primary

mirror_endpoint_name login_name permission_name permission_state endpoint_state
Mirroring DomainName\username CONNECT...

Thanks for your response.Yes, the end point are started and I can connect to the DR instance from Primarymirror_endpoint_namelogin_name permission_name ...

Thanks for your response.Yes, the end point are started and I can connect to the DR instance from Primarymirror_endpoint_namelogin_name permission_name ...

Thanks for your response.Yes, the end point are started and I can connect to the DR instance from Primarymirror_endpoint_namelogin_name permission_name ...

Thanks for your response.Yes, the end point are started and I can connect to the DR instance from Primarymirror_endpoint_namelogin_name permission_name ...

Thanks for your response.Yes, the end point are started and I can connect to the DR instance from Primarymirror_endpoint_namelogin_name permission_name ...