Uninstall and Remove Master Data Services
Applies To: SQL Server 2016 Preview
To uninstall the Master Data Services feature from an instance of SQL Server, follow the steps in Uninstall an Existing Instance of SQL Server (Setup) and specify Master Data Services as a feature to remove on the Select Features page. The uninstall process removes Master Data Services folders and files, and uninstalls Master Data Services Configuration Manager from the local computer.
To prevent data loss and avoid affecting other computers in the system, some items are not removed or changed by the uninstall process. Review the following table to determine whether to leave or remove items.
Folders and files
The uninstall process removes most folders and files from the installation path.
The uninstall process does not remove the Master Data Services and MDSTempDir folders from the installation location. After the uninstall process is complete, you can manually delete these folders from the file system. For more information, see Folder and File Permissions (Master Data Services).
Master Data Services assemblies
The uninstall process removes Master Data Services assemblies from the Global Assembly Cache (GAC).
The uninstall process does not affect the Master Data Services database. The database remains intact in the instance of Database Engine so that you do not lose any data, including master data, model objects, user and group permissions, business rules, and so on.
If you do not need the database, and do not anticipate connecting it to another Master Data Services web site or application in the future, you might want to delete the database from the instance of Database Engine that hosts it. For more information, see Delete a Database.
Master Data Services and Web.config
The uninstall process removes the WebApplication folder from the file system. The WebApplication folder contains the web application files and Web.config file for Master Data Services.
Internet Information Services (IIS) items
The uninstall process does not affect any application pools, web sites, or web applications in IIS on the local computer. Because the uninstall process removes the WebApplication folder and Web.config file for Master Data Services, any Master Data Services web applications that require those files will no longer serve content. If users try to access the web application, they will receive HTTP Error 500.19-Internal Server Error: "The requested page cannot be accessed because the related configuration data for the page is invalid."
If you no longer require the web site or application, and the application pool serving your site or application, you can use an IIS tool to delete them. For more information, see IIS 7 Operations Guide on Microsoft TechNet.
After the uninstall process is complete, the MDS_ServiceAccounts Windows group and any service accounts added to the group remain. If you no longer need the group and accounts, you can remove them.
The uninstall process removes all Master Data Services registry keys from the Windows registry.