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

About James Serra

James currently works for Microsoft specializing in big data and data warehousing using the Analytics Platform System (APS), a Massively Parallel Processing (MPP) architecture. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence/MDM architect and developer, specializing in the Microsoft BI stack. He is a SQL Server MVP with over 25 years of IT experience.
This entry was posted in MDS/MDM, SQLServerPedia Syndication. Bookmark the permalink.

3 Responses to MDS: The Microsoft SQL Server license has expired

  1. Kevin Hough says:

    Hi James,
    This got me past a nasty problem! Keep the tips coming.

    Kevin Hough

  2. Michael Gyekye says:

    MDS is a 64 bit application,so its application pool should be set such that only 64bit web application is allowed.
    To do this , open IIS Manager -> MDS Application Pool -> Advanced Settings .
    Look for Enable 32 bit Applications Setting (under General). Set it to false and recycle application pool.
    This is how I managed to solve the problem: “host:8080/EvaluationExpired.aspx” error.
    I hope this helps.

  3. Andrew Notarian says:

    Michael is 100% correct on this. Setting the App Pool to not allow the fallback to 32-bit mode is the permanent solution to the problem. If you leave the x86 sqlboot.dll in place you will have issues with other SQL Server components and be unable to install services packs or other updates.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>