Error - Data Quality Server Installer on Windows 8 x64

Question

I have installed SQL 2012 Enterprise x64 on Windows 8. Everything installed fine and I have completed the configuration of all other tools. Running Data Quality Server Installer from elevated prompt, non-elevated prompt same from menu link generates the following error:

...

[1/30/2013 9:59:55 AM] Successfully registered all 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 and 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 the 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 the DQS installer.
Microsoft.Ssdqs.Infra.Exceptions.EntryPointException: The Data Quality Services license validation has failed.
   at Microsoft.Ssdqs.Proxy.Database.DBAccessClient.Exec()
   at Microsoft.Ssdqs.Proxy.EntryPoint.NotificationEntryPointClient.NotificationSessionCreate(ClientType clientType)
   at Microsoft.Ssdqs.DqsInstaller.Logic.Actions.LoadOutOfTheBoxDataAction.Execute()
   at Microsoft.Ssdqs.DqsInstaller.Logic.ActionExecuter.ExecuteAllActions()
   at Microsoft.Ssdqs.DqsInstaller.Logic.Installer.Main(String[] args)

The error seems to happen on

[1/30/2013 9:59:56 AM] Executing action: Load out of the box data.

I have attempted the -upgradedlls as well as all recommendations in KB's that I found on the DQS Wiki. I get the same error. I have reinstalled OS, same error. Thinking it was the download bits, I installed on a Windows 7 PC and it works just fine.

Anyone else run into this? Without me having to loadup the debug symbols, does anyone know what "Load out of the box data." is?

Thanks in advance.

Patrick

---

--Patrick Gallucci

Answer 1

What I have found...Looking at the debug...The last action that executes correctly is CreateMdsUserAction()

Notice that connection parameter sends the 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 * FROM sys.syslogins WHERE loginname = '{1}\\MDS_ServiceAccounts') AND\r\n               NOT EXISTS (SELECT * FROM sys.sysusers WHERE name = 'MDS_ServiceAccounts')\r\n            BEGIN\r\n               CREATE USER [MDS_ServiceAccounts] FOR 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 is true for all actions sent to the DB except for the 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, I never see this command reach the DB. The last one is the Create MDS user...

So why does this work on Windows 7 and not Windows 8?

Ill keep digging...

---

--Patrick Gallucci

Answer 2

Make sure your %TMP% folder works.

Make sure the scripts are unzipped into that folder.

Check if SQLCMD.exe runs well from the command prompt (windows uses the %path% environment variable to find the tool). Make sure it is the right version of SQLCMD and not another instance.

I have it running on several copies of Win 8, so it works on Win 8 in general.

Thanks, Jason

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

Answer 3

Patrick...curious whether you found resolution to this issue. I'm seeing what seems to be the same behavior that you describe.

Thanks,

Phil

Answer 4

In my case, I was running an instance of SQL Server 2008 R2. I was able to resolve this issue by uninstalling SQL Server 2008. Alternatively, I think I could have upgraded 2008 to the latest service pack, but I chose to uninstall.

Not sure if this matches your situation or not...

Thanks,

Phil