1

What I'm trying to do: I trying to setup SQL Server log shipping between my desktop and Oracle Cloud. I have a developer edition of MSSQL installed in both my desktop and Oracle Cloud instance.

Windows Server in Cloud instance is in workgroup. SQL Server 2014 database

What issues i'm facing: I have RDP access to my Cloud instance. Cloud instance is having one public IP and a private IP and a hostname attached to it. SQL Server is registered with the hostname and the hostname is mapped to the private IP. The hostname is not registered in DNS.

While setting up SQL Server Log Shipping, it asks for Secondary Server name as given in the below snap:

enter image description here

Here, if I give the public IP of the Cloud instance, it is not able to connect to the server. Also, i'm not able to connect via hostname, because it is not registered in DNS, and obviously Private IP is private to the instance.

Since SQL Server is local to the respective Private IP and hostname mapped to it, i'm facing issues connecting to the Cloud instance.

Resolution?: 1. Where is the problem? Should I open some additional ports in the cloud, since I have already checked firewall is off in the cloud instance and inbound network rules are open.

  1. Is DNS registration mandatory here? Or is some kind of rerouting that needs to be done?

I hope it is appropriate to ask this question in this forum.

tesla747
  • 113
  • 4

1 Answers1

0

Have you tried adding a dns host record on your local pc? Windows routes DNS first to its local hosts table, then your immediate network router before reaching out to your internet provider's DNS servers and upward.

You can add your own record by editing as administrator the windows etc\hosts file. This rackspace post has common paths to the file for recent versions of Windows: https://support.rackspace.com/how-to/modify-your-hosts-file/

After adding or modifying a host entry in windows, you usually need to flush your dns cache before loading the application and requesting said domain.

This article demonstrates how to do so in Win10, but command hasn't changed and is same in 7, 8, and windows server as well. https://www.technipages.com/flush-and-reset-the-dns-resolver-cache-using-ipconfig

NOTE: this approach is intended only for a single instance local pc connection, if other devices on same network need access, you can try this at the network server level.

Anson W Han
  • 394
  • 1
  • 6