Error - Data Quality Server Installer on Windows 8 x64


i have installed sql 2012 enterprise x64 on windows 8. installed fine , have completed configuration of other tools. running data quality server installer elevated prompt, non-elevated prompt same menu link generates following error:

...

[1/30/2013 9:59:55 am] registered assemblies.
[1/30/2013 9:59:55 am]
[1/30/2013 9:59:55 am]
[1/30/2013 9:59:55 am] action 'register data quality assemblies , stored procedures' finished successfully.
[1/30/2013 9:59:55 am] executing action: set product version property.
[1/30/2013 9:59:55 am] action 'set product version property' finished successfully.
[1/30/2013 9:59:55 am] executing action: create mds user (if mds login exists).
[1/30/2013 9:59:55 am] action 'create mds user (if mds login exists)' finished successfully.
[1/30/2013 9:59:56 am] executing action: load out of box data.
[1/30/2013 9:59:56 am] starting installation rollback...
[1/30/2013 9:59:56 am] installation rollback completed successfully.
[1/30/2013 9:59:56 am] fatal error while executing dqs installer.
microsoft.ssdqs.infra.exceptions.entrypointexception: data quality services license validation has failed.
   @ microsoft.ssdqs.proxy.database.dbaccessclient.exec()
   @ microsoft.ssdqs.proxy.entrypoint.notificationentrypointclient.notificationsessioncreate(clienttype clienttype)
   @ microsoft.ssdqs.dqsinstaller.logic.actions.loadoutoftheboxdataaction.execute()
   @ microsoft.ssdqs.dqsinstaller.logic.actionexecuter.executeallactions()
   @ microsoft.ssdqs.dqsinstaller.logic.installer.main(string[] args)

the error seems happen on

[1/30/2013 9:59:56 am] executing action: load out of box data.

i have attempted -upgradedlls recommendations in kb's found on dqs wiki. same error. have reinstalled os, same error. thinking download bits, installed on windows 7 pc , works fine.

anyone else run this? without me having loadup debug symbols, know "load out of box data." is?

thanks in advance.

patrick


--patrick gallucci

what have found...looking @ debug...the last action executes correctly createmdsuseraction()

notice connection parameter sends machine name in objarray

string machinename = environment.machinename;
string str = string.concat(argumentparser.catalog, "_main");
object[] objarray = new object[2];
objarray[0] = str;
objarray[1] = machinename;
string str1 = string.format(cultureinfo.invariantculture, "\r\n            use [{0}]\r\n            if exists (select * sys.syslogins loginname = '{1}\\mds_serviceaccounts') and\r\n               not exists (select * sys.sysusers name = 'mds_serviceaccounts')\r\n            begin\r\n               create user [mds_serviceaccounts] login [{1}\\mds_serviceaccounts]\r\n               exec sp_addrolemember @rolename='dqs_administrator', @membername='mds_serviceaccounts'\r\n            end", objarray);
sqlconnection connection = installerutility.getconnection(argumentparser.instance);
using (connection)
{
 connection.open();
 sqlcommand sqlcommand = new sqlcommand(str1, connection);
 sqlcommand.executenonquery();
}

this true actions sent db except loadoutoftheboxdataaction

  object[] objarray1 = new object[1];
   objarray1[0] = str;
   string str1 = string.format(cultureinfo.invariantculture, "\r\n            use [{0}]\r\n            update [a_knowledgebase]\r\n            set [created_by] = 'system', [published_by] = 'system'", objarray1);
   sqlconnection connection = installerutility.getconnection(argumentparser.instance);
   using (connection)
   {
    connection.open();
    sqlcommand sqlcommand = new sqlcommand(str1, connection);
    sqlcommand.executenonquery();
   }

running sql profiler, never see command reach db. last 1 create mds user...

so why work on windows 7 , not windows 8?

ill keep digging...


--patrick gallucci



SQL Server  >  SQL Server Data Quality Services



Comments

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........