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
Post a Comment