MSSQL DNS and IP after migration

Hi all,

According to Stephen’s post (see here) mssql2, mssql3 and mssql5 (all cluster1) have been migrated.
Also stated in this post is that there are dns issues (if I am correct web3).

But also for mssql2,3 and 5 there are dns issues. a A-record DNS-lookup for mssql2.m****here.biz does not return anything. Same for mssql3 and mssql5.

In my own reseller DNS still the old IP’s are listed.

In migrationlist ( http://status.jodohost.com ) mssql2, 3 and 4 are listed as not migrated, and ip lookup for old IP’s fails.

My sites using mssql3 have problems loading currently, because communication to old ip crosses 2 times dc-lines. Can please anyone share new IP adresses for mssql2, 3 and 5?

Thanks,
Jan-Pieter

it should be working on old IP to new, as we didn’t edit that yet at all jsut doing ip redirection at moment until tonight..
but the new IPs are

mssql2 173.0.129.31
mssql3 173.0.129.32
mssql5 173.0.129.34
mssql6 will be 173.0.129.35

1 Like

Hi Stephen,
Jodoshared.com IP’s for mssql2,3,5 still pointing to old IP’s. I have one site with a lot of connectionstrings to jodoshared.com, and this site has intermittent sql connection errors. Can you get DNS updated for mssql on the jodoshared.com domain?
Thanks!

They were supposed to have processed in the cp outage last night, it will happen on win13 restore for sure.

They did happen, just seeing a bit of a cache effect:

C:\Users\Stephen>nslookup mssql1.jodoshared.com ns2.jodoshared.com
Server: ns2.m****here.biz
Address: 173.0.138.4

Name: mssql1.jodoshared.com
Address: 173.0.129.30

Hi Stephen, sorry for my impatience!

mssql1.jodoshared.com was allready ok (migrated earlier). DNS lookup on mssql2, 3 and 5 still providing old 204.x IP’s…

C:\Users\jp>nslookup mssql2.jodoshared.com ns2.jodoshared.com
Server: ns2.m****here.biz
Address: 173.0.138.4

Naam: mssql2.jodoshared.com
Address: 204.14.107.224

But no problem if this problem solves itself tonight!

Have a good evening and sleep (probably first complete night for you since friday?)
Regards, Jan-Pieter

Yes, jodoshared mssql DNS IPs have been updated now!!!
Reseller DNS not yet, but no issue for me.

I noticed today that 1433 direct SQL remote access still possible on old IP. Is this via IP redirect to new migrated servers? Any idea how long this will be available?

And also any idea when /mssql/backup.aspx will become available for mssql3? (to be able to backup/restore myself)

Thanks!

ip redirect yes, as that is an authorized ip.

it will go down…probably next week or so maybe a week more, we will send one email with all new MySQL and MSSQL IPs for reference first.

backup page, I will work on in next weeks, my focus has been foremost in primary function here, the backups are important I know and they aren’t going away forever :slight_smile:

We have sent a full list of all SQL servers old and new IPs for reference to resellers as well as posted to announcements