locked
MDS Denali UI on top of SQL Server 2008 R2? RRS feed

  • Question

  • Hi,


    I have tried to install Master Data Services (Denali CTP-3) on top of SQL Server 2008 R2 (running on Windows Server 2008 R2), but it seems to fail the installation.

     

    • During the installation of Denali I only checked "Master Data Services". All rules are checked successfully, but the installation fails and shows the following errors:
      - "Error writing to file: "Microsoft.MasterDataServices.Common.dll. Verify that you have access to that directory."
      - "The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2350."
    • I also tried to fully install Denali on the same clean (without SS 2008 R2) Windows Server 2008 R2, which works perfectly.


    It seems that only installing Master Data Services is not enough to install it properly... Does anyone has a solution for this one?

    Regards,

    Johan Machielse
    Business Intelligence Consultant

    Monday, July 18, 2011 8:38 PM

Answers

All replies

  • Hi Johan,

    I've tried connecting the new Excel add-in to MDS in SQL 2008 R2 and that doesn't seem to work unfortunately.

    As for installing it on top of SQL Server 2008 R2 - I've not tried that. But your problem with an error writing to the file "Microsoft.MasterDataServices.Common.dll" may be due to the fact that this dll is part of the current SQL Server 2008 R2 installation and may well be locked, due to being used by the current web app.

    Regards

    Jeremy


    http://blogs.adatis.co.uk/blogs/jeremykashel/default.aspx If a post answers your question, please click the Mark As Answer button.
    Thursday, July 21, 2011 8:26 AM
  • Hi Jeremy,

    Connecting the Excel add-in with SQL Server 2008 R2 does not work, because the add-in requires the new Denali MDS WCF API. According to speaker in the presentation http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DBI204 it should be possible to install Denali MDS on top of SQL Server 2008 R2 to make use of the Excel add-in and the new Denali user interface. That's what I tried to do, but failed.

    Your remark that the above mentioned file could be locked is not really the case I think, because:
    - I only installed SQL Server 2008 R2 without Master Data Services
    - I searched on the server and there was no file called "Microsoft.MasterDataServices.Common.dll"

    One of our clients is really not happy with the current UI (and I can imagine that) and just rolled out SQL Server 2008 R2 throughout whole the company. An update to SQL Server Denali is not an option for them right now, so that's why I tried to only use the Denali UI on top of SQL Server 2008 R2. But unfortunately this did not help... There's a good chance they will use Profisee instead for the user interface.

    Regards,

    Johan Machielse
    http://johanmachielse.blogspot.com/

    Thursday, July 21, 2011 9:12 AM
  • Hi Johan,

    Have you checked in C:\Program Files\Microsoft SQL Server\Master Data Services\WebApplication\bin\ ?

    That's where Microsoft.MasterDataServices.Common.dll is on my server, and the server only has SQL Server 2008 R2 installed.

    HTH

    Jeremy


    http://blogs.adatis.co.uk/blogs/jeremykashel/default.aspx If a post answers your question, please click the Mark As Answer button.
    Thursday, July 21, 2011 9:21 AM
  • Hi all,

    I solved the issue and described the solution in a nice blog article: http://johanmachielse.blogspot.com/2011/08/master-data-services-denalis-master.html

    Here's the thread that helped me to solve the issue: http://social.msdn.microsoft.com/Forums/en-US/sqldenmds/thread/5010609f-bbcf-4406-bcba-27b806261909/

    Regards,

    Johan Machielse
    Business Intelligence Consultant
    http://johanmachielse.blogspot.com/

    Thursday, August 4, 2011 2:32 PM