SQL Server 2019 Master Data Services Excel Add-in issue on new server

Hi Reinero Joel,

Thanks for reaching out to SQL Q&A Forum

1. Reinstall/Configure MDS Web Application

• On the new Windows Server 2019, open Master Data Services Configuration Manager.
• Create or configure a new Web Application in IIS pointing to the migrated MDS database.
• Ensure the site has a valid application pool and bindings (HTTP/HTTPS).

 2.Check URL in Excel Add-in

• In the Excel Add-in, use the exact URL of the MDS service (without extra path segments like /bhb unless configured).
• Authentication & HTTPS
• If you switched to HTTPS, update bindings and certificates in IIS.
• The Excel Add-in may require editing the web.config to support HTTPS connections.
• Firewall & DNS
• Ensure the client machine can resolve svsidpbipro.rtm.lan and reach the server over the correct port (default 80 for HTTP, 443 for HTTPS).

Hope this help!

Thanks,

Lakshmi.

The Excel add-in error indicates that the URL it is trying to reach is either invalid or not a supported MDS web application, and the HTTP 404 confirms that there is no MDS service endpoint at the specified address.

From the context, the Excel add-in connects to MDS by using the URL of the Master Data Manager web application as its connection string, for example:

https://contoso/mds

Key checks and fixes in this migration scenario:

1. Verify the MDS web URL
   • Confirm that the Master Data Manager site is correctly deployed and accessible in a browser on the new server (for example http://<server>/MDS or https://<server>/MDS).
   • Ensure that the path /service/service.svc exists under that site and is reachable in a browser (no 404).
2. Update the Excel add-in connection
   • In the Master Data Services Add-in for Excel, edit or recreate the connection so that the connection string is the correct Master Data Manager URL for the new server (for example http://<newserver>/MDS).
   • Do not reuse the old server URL; the add-in must point to the new MDS web application, not just the migrated database.
3. Confirm MDS version and add-in version
   • Ensure that the MDS web application version on the new SQL Server 2019 instance matches a supported Excel add-in version for SQL Server 2019.
   • If needed, install the “Master Data Services Add-in for Excel for SQL Server 2019” on the client and connect using the new URL.
4. Ensure MDS is fully configured on the new server
   • Migrating only the databases is not sufficient; the MDS web application must also be deployed and configured on the new Windows Server 2019 instance so that the /service/service.svc endpoint is created.

Once the MDS web site and its /service/service.svc endpoint are correctly deployed and the Excel add-in connection string is updated to the new Master Data Manager URL, the 404 and “URL not valid or version not supported” errors should be resolved.

References:

• Connections (MDS Add-in for Excel)
• Master Data Services Add-in for Microsoft Excel
• What's New in Master Data Services (MDS)