Share via

Setup issue to SQL Server Management studio installer 22

Jonathan 85 Reputation points
2026-05-31T04:46:30.6333333+00:00

Hi,

When doing the setup of SQL Server Management studio installer 22 on Windows server 2025, I got "internet connection, and not able to do the download". How to find out the issues on the server for this?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories


Answer accepted by question author

Deepesh Dhake 80 Reputation points
2026-06-02T16:15:41.7966667+00:00

It looks like problem is DNS, not connectivity or firewall. You can try following in order.

  1. See what DNS actually does with the name:
Resolve-DnsName aka.ms
nslookup aka.ms
  1. Check which DNS servers the box is using:
Get-DnsClientServerAddress
ipconfig /all

Look at the configured DNS server entries. If they're empty, pointing at a dead internal resolver, or pointing at something that only serves internal zones, that's your failure.

  1. Test against a known-good public resolver to isolate the fault:
Resolve-DnsName aka.ms -Server 8.8.8.8
nslookup aka.ms 8.8.8.8

If 8.8.8.8 resolves it fine but your configured DNS doesn't, the problem is your DNS server / network config, not the host or the internet.

  1. Check the hosts file for stray entries (this explains the earlier bogus-IP behavior):

C:\Windows\System32\drivers\etc\hosts

  1. Flush and retry:
ipconfig /flushdns
Resolve-DnsName aka.ms

Was this answer helpful?

1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. Deepesh Dhake 80 Reputation points
    2026-06-01T19:24:55.0866667+00:00

    You can try following check:

    1. Test basic connectivity like "ping" test
    2. Check proxy settings like "netsh winhttp show proxy".
    3. Test HTTPS outbound like "Test-NetConnection -ComputerName aka.ms -Port 443"

    Most likely causes:

    • Outbound port 443 blocked by firewall
    • Proxy required but not configured
    • Group Policy restricting internet access

    Was this answer helpful?


  2. AI answer

    2026-05-31T04:46:44.8966667+00:00

    Use the Visual Studio Installer and SSMS logs to pinpoint why the SSMS 22 bootstrapper cannot download packages, and then validate network/offline prerequisites.

    1. Confirm basic requirements
    • Ensure the Windows Server 2025 machine has:
      • Working internet access (test with a browser from that server).
      • Required certificates and TLS configuration if using a proxy or SSL inspection.
      • Microsoft Visual C++ v14 Redistributable (x86 and x64) if planning an offline layout later.
    1. Try a clean online install/update
    • Download the latest SSMS 22 bootstrapper (vs_SSMS.exe) from the official SSMS installation page.
    • Run it once to let it install/update the Visual Studio Installer. If the Choose Workloads page appears, the installer itself is healthy.
    • If the download still fails with the same internet error, proceed to troubleshooting steps below.
    1. Repair or reset the Visual Studio Installer Online SSMS installs use the Visual Studio Installer engine. If it is corrupted, downloads can fail.
    • Close the Visual Studio Installer.
    • Delete the folder:
      • C:\Program Files (x86)\Microsoft Visual Studio\Installer
    • Run the SSMS bootstrapper again (vs_SSMS.exe) to reinstall the Visual Studio Installer and reset installation metadata.
    • Retry the SSMS installation.
    1. Check for known issues and logs
    • Review known issues for SSMS/Visual Studio Installer to see if the download problem is a documented issue.
    • If installation continues to fail:
      • Collect logs using the Microsoft Visual Studio and .NET Framework log collection tool (collect.exe) as described in the troubleshooting article.
      • The tool generates vslogs.zip in %TEMP%. Inspect or provide this to support to see the exact network/HTTP errors during package download.
    1. Use “Download all, then install” (semi‑offline) If the server’s internet is slow or unstable but still reachable:
    • Run vs_SSMS.exe on the server.
    • In Visual Studio Installer, choose SSMS components and then select Download all, then install from the dropdown next to Install.
    • This downloads all required packages locally first; installation then runs from the local cache, reducing sensitivity to intermittent connectivity.
    1. Fully offline layout (if server has no internet) If the server truly has no internet access:
    • On a different machine with internet, use the command line to create a local layout with vs_SSMS.exe as described in the offline installation article.
    • Copy the layout folder to the Windows Server 2025 machine.
    • Install SSMS from the layout using vs_SSMS.exe --noWeb so it does not attempt any online download.
    1. If issues persist
    • Verify that corporate firewalls/proxies are not blocking Visual Studio/SSMS endpoints.
    • If still failing after the above steps, collect logs with collect.exe and open a case or use Report a problem from the Visual Studio Installer for case‑by‑case analysis.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.