Troubleshoot: SQL VM unreachable after someone “fixed” its IP inside Windows

حل مشكلة: ‏VM الـ SQL مقطوعة بعد ما حد "ثبّت" الـ IP من جوه Windows

Ticket #5320 (priority: critical) — "The application on vm-app01 (Ubuntu, 10.80.1.4) can no longer connect to SQL Server on vm-sql01 (Windows). Last night a junior admin logged on to vm-sql01 and set a static IP 10.80.1.50 in the Windows network adapter, because the app connection string was changed to 10.80.1.50 and ‘the IP must never change’. Since then RDP to vm-sql01 fails too. Azure shows the VM as Running." Find the root cause without network access to the VM, fix it the Azure way while keeping 10.80.1.50 as the SQL address, and prove the app can connect.

The 4 tasks you will do

• Task 1 — Diagnose from Azure: is it the network path?المهمة 1 — التشخيص من Azure: هل المشكلة في طريق الشبكة؟
• Task 2 — Look inside the guest without network accessالمهمة 2 — بص جوه الـ OS من غير اتصال شبكة
• Task 3 — Fix it the Azure way (keep 10.80.1.50)المهمة 3 — صلّحها بطريقة Azure (وخلّي 10.80.1.50)
• Task 4 — Prove the application can connectالمهمة 4 — اثبت إن التطبيق بقى بيتصل