SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

MDS: The Microsoft SQL Server license has expired

When installing Master Data Services (MDS) in SQL Server 2012 or installing SQL Server 2012 sp1 (and possibly a CU), you might see the message “The Microsoft SQL Server license has expired” when trying to pull up the MDS web UI.  The page is redirected to ‘/MDS/EvaluationExpired.aspx’ with the title “Evaluation period expired”.  If you turn on trace logging you will see:

MDS Error: 0 : Error 193 (0x000000c1). Unable to load sqlboot.dll from path: C:\Program Files\Microsoft SQL Server\110\Shared\sqlboot.dll

This problem only seems to happen on a server that has SQL Server 2008 R2 installed, even if SQL Server 2008 R2 has been un-installed.

The solution is:

  1. Rename the C:\Program Files\Microsoft SQL Server\110\Shared\sqlboot.dll to C:\Program Files\Microsoft SQL Server\110\Shared\sqlboot.dll.x64
  2. Copy the C:\Program Files (x86)\Microsoft SQL Server\110\Shared\sqlboot.dll to C:\Program Files\Microsoft SQL Server\110\Shared\sqlboot.dll
  3. Start and stop the MDS Application Pool

Then it will work!

More info:

MDS Error: 0 : Evaluation period has expired

MDS: The Microsoft SQL Server licence has expired – CTP upgrade

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.


Leave a comment on the original post [www.jamesserra.com, opens in a new window]

Loading comments...