MDS SQL Server 2012 RC0. Evaluation License expired

Question

If I start a new Website connecting to Master Data Service database, which resides in a SQL Server 2012 RC0 instance, my website is beeing forwarded to the site 'host:port/EvaluationExpired.aspx' showing the text 'The Microsoft SQL Server license is expired'. I downloaded and installed SQL Server 2012 RC0 five days ago! What can I do, to test the MDS?

Answer 1

Hi Herggo,

Can you try turning on trace logging ("Information", "Verbose" or "All" trace level) and see if you get any additional messages in the log?  There are a couple of reasons that you might see this message, and having the log info can help narrow it down.

Thanks!

Mark

---

This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

Hi Mark,

trace logging is switched on, and I got the following output to the trace file:

MDS Stop: 2 : HostContext.GetHostContext
    DateTime=2011-12-02T10:19:40.2212260Z
MDS Start: 1 :
                  Begin operation: ExecuteRequest
                  Host info:       http://172.21.224.89:7777/default.aspx
                  User Name:       EURO01\herggo
                  Time:            12/02/2011 11:19:40
    DateTime=2011-12-02T10:19:40.3022422Z
MDS Verbose: 0 : Request message:
<SystemSettingsGetRequest xmlns="http://schemas.datacontract.org/2004/07/Microsoft.MasterDataServices.Services.MessageContracts" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <International i:nil="true" xmlns:a="http://www.w3.org/2005/09/ws-i18n" />
  <SearchCriteria xmlns:a="http://schemas.microsoft.com/sqlserver/masterdataservices/2009/09">
    <a:Group i:nil="true" />
  </SearchCriteria>
</SystemSettingsGetRequest>
    DateTime=2011-12-02T10:19:40.3452508Z
MDS Error: 0 : Evaluation period has expired.
    DateTime=2011-12-02T10:19:40.3842586Z
MDS Stop: 2 :
                  End  operation: SystemSettingsGet
                  Host info:       http://172.21.224.89:7777/default.aspx
                  User Name:       EURO01\herggo
                  Time:            12/02/2011 11:19:40
    DateTime=2011-12-02T10:19:40.3922602Z
MDS Verbose: 0 : Response message:
<SystemSettingsGetResponse xmlns="http://schemas.datacontract.org/2004/07/Microsoft.MasterDataServices.Services.MessageContracts" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <OperationResult xmlns:a="http://schemas.microsoft.com/sqlserver/masterdataservices/2009/09">
    <a:Errors />
    <a:RequestId>ce895f89-03bd-44a9-abb6-0cf4bf3c78e8</a:RequestId>
  </OperationResult>
  <SystemSettingsGroups xmlns:a="http://schemas.microsoft.com/sqlserver/masterdataservices/2009/09" />
</SystemSettingsGetResponse>
    DateTime=2011-12-02T10:19:40.4352688Z
MDS Error: 0 : LogError : Die Microsoft SQL Server-Lizenz ist abgelaufen.
    DateTime=2011-12-02T10:19:40.4392696Z

CAn you see here whats wrog?

regards

herggo

Answer 3

Hi herggo,

Unfortunately, what I was hoping to see is not present in the log output you listed.

Can you see if you have MDS Start and MDS Stop messages elsewhere in your log with the text "Service.InitializeExpirationStatus
"?  What I am looking for should be wrapped in that section.  In order to get this, you would need to actually stop and restart MDS (restart the app pool in IIS) since this code only executes on startup (otherwise a cached value is used).  Please let me know if you need more details, and my appologies for not providing this step initially!

Thanks,

Mark

---

This posting is provided "AS IS" with no warranties, and confers no rights

Answer 4

Hi Mark,

yes you are right. The first entry in the log file is that what you expected:

DS Start: 1 : Service.InitializeExpirationStatus
    DateTime=2011-12-05T09:31:38.1332689Z
MDS Error: 0 : Error 193 (0x000000c1). Unable to load sqlboot.dll from path: C:\Program Files\Microsoft SQL Server\110\Shared\sqlboot.dll
    DateTime=2011-12-05T09:31:38.1482689Z
MDS Stop: 2 : Service.InitializeExpirationStatus
    DateTime=2011-12-05T09:31:38.1772689Z
MDS Start: 1 : HostContext.GetHostContext
    DateTime=2011-12-05T09:31:38.2012689Z
MDS Information: 0 : The host context is detected to be ASP.NET.
    DateTime=2011-12-05T09:31:38.2012689Z
MDS Information: 0 : Successfully set culture to 'de-de'.

    DateTime=2011-12-05T09:31:38.2022689Z

The permissions of the dll and the directory are OK ( read and execute for users and administrators; and I'm an administratort ).

Trying to register the dll with regsrv32 was not successful . I got the follwing message:

The module ""%1"" was loaded but the entry-point %2 was not found.\n\nMake sure that ""%1"" is a valid DLL or OCX file and then try again

Is the sqlboot.dll of a wrong version?

Thanks for helping

herggo

Answer 5

Hi Herggo,

Is your SQL Server installation 32-bit or 64-bit?  One reason for that error message is that the sqlboot.dll at the specified location is 32-bit, but MDS is expecting to find a 64-bit version (MDS is 64-bit only).

Did you perhaps do an MDS-only install on top of a 32-bit SQL Server engine installation?

 

Thanks

Mark

---

This posting is provided "AS IS" with no warranties, and confers no rights

Answer 6

Hi Mark, my SQLServer installation is 64 bit. I think the sqlboot.dll under the path c:\program files\Microsoft SQL Server\110\Shared is 64 bit too. The 32 bit version can be found in C:\Program Files (x86)\Microsoft SQL Server\110\Shared. Both files have the same version number, but differ in size. Maybe there is another reason that MDS doesn't work Thanks, herggo

Answer 7

Hi Herggo,

May I request a bit more information?

1. What is the product version of sqlboot.dll (as shown in Details tab of properties window from Explorer)?
2. Can you run dumpbin from a cmd prompt as below, and report the output?

C:\Program Files\Microsoft SQL Server\100\Shared>dumpbin /headers sqlboot.dll
Microsoft (R) COFF/PE Dumper Version 10.10.30716.10
Copyright (C) Microsoft Corporation.  All rights reserved.

Dump of file sqlboot.dll

PE signature found

File Type: DLL

FILE HEADER VALUES
            8664 machine (x64)
               5 number of sections
        4EC01B81 time date stamp Sun Nov 13 11:33:21 2011
               0 file pointer to symbol table
               0 number of symbols
              F0 size of optional header
            2022 characteristics
                   Executable
                   Application can handle large (>2GB) addresses
                   DLL

OPTIONAL HEADER VALUES
             20B magic # (PE32+)
<you can clip the rest>

3. Can you try temporarily renaming the sqlboot.dll in the Program Files (x86) location to something else (just to eliminate that possibility that the wrong one is being loaded)?

Thanks!
Mark

---

This posting is provided "AS IS" with no warranties, and confers no rights