A reader emailed me to ask about where is the SQL Server Master Data manager Web UI? I guess, the reader might not recollect the URL that was created after the successful installation of Master Data Services. – And in fact, I had forgotten the Master Data Manager Web UI url once too and this how I got the URL of the master data manager web UI:
1. Start > IIS Manager
2. Find the site from the sites section of the IIS manager:
3. click on Browse the site and it would open the site.
4. After the site opens, you would also get a chance to see the location of the site
That’s about it.
This might not be new to most of you, but I hope that this helps someone out there who might need a pointer about searching for the URL of the Master Data manager web UI.
Conclusion:
In this blog-post, we saw how to see the location of the Master data manager web UI via the IIS manager.
As I mentioned, these are post-sql-server-installation tasks and so I assume you have your BI environment using SQL Server 2012 already up. The official note can be found here: Install Master Data Services
For the purpose of this blog-post, we’ll break the steps into three main sections:
1. Create MDS Database
2. Create Master Data Management Web Application
3. Associate MDS database w/ web Application
So, let’s get started:
Got to: Start > SQL Server 2012 > Master Data Services > Master Data services Configuration
1. Create MDS Database
1a: click on Create Database:
1b: Enter the instance name and credentials:
1c: specify the MDS database name and collation:
1d: Specify the Administrator Account and review the summary. After it installs successfully – you’ll see a message:
2. Create Master Data management Web Application
2a. Switch to Master Data Services configurations > web configuration > select Create new website
2b. Specify configuration details for the website:
Here’s what I entered:
Website Name: MDS
Port: 81
Host Header: Left it blank
Entered username and password
2c. Click on OK and in the web configuration dialog box, click on Create Application
3. Associate MDS database w/ web Application
3a. Under the Associate Application with Database click on Select
3b. Select the database that will get associated to the application selected.
* I selected the database that I had created in Step 1
3c. After successful installation, you’ll see a message:
The web application is then launched in the browser, here you’ll see getting started guide, videos and MDS Samples. Go Explore!
Conclusion
In the blog post, we saw the three post installation tasks for Master Data Services w/ SQL Server 2012.