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

SQL Server PSProvider SQL Server Authentication

BIT Version

How to calculate the delta size while diffing the files in TeamFoundationServer ?