When trying to install eConnect on GP 2010, I receive the following error: Some or all identity references could not be translated.
A little history about this server,
This machine is the SQL Server, and is running GP. It is named MSDYN, but it used to be off-domain. It was added to the domain AFTER SQL server was installed and GP was up and running. The machine is still named MSDYN, but now, of course, it has a domain in front of it. The system has been running as is without any problems, but when I try to install eConnect the error above is returned.
The MSSQL Service account has been set as Local System and also as the Local Admin with the same results. However, if the MSSQL Service account is set to Network service, the error returned is "Unable to add user to SQL"
What do you think is wrong, and how can I fix it?
Kind regards,
Leslie
Here are the versions involved:
Microsoft Dynamics GP 2010 build 11.00.2106
eConnect 11.00.2111.00
Microsoft SQL Server Management Studio 10.50.1617.0
Microsoft Analysis Services Client Tools 10.50.1617.0
Microsoft Data Access Components (MDAC) 6.0.6002.18005
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.4241
Operating System 6.0.6002 (Windows Server 2008 R2)
I think the info below is the relevant part from the windows installer log:
System.Security.Principal.IdentityNotMappedException: Some or all identity references could not be translated.
at System.Security.Principal.SecurityIdentifier.Translate(IdentityReferenceCollection sourceSids, Type targetType, Boolean forceSuccess)
at System.Security.Principal.SecurityIdentifier.Translate(Type targetType)
at Microsoft.Dynamics.GP.Deployment.AccountSidTranslator.NameFromId(String id)
at Microsoft.Dynamics.GP.Deployment.Networking.HttpApiSddlManager.AccountEntriesFromSids(IEnumerable`1 aceSidEntries)
at Microsoft.Dynamics.GP.Deployment.Networking.HttpApiSddlManager.GetSddlStringAccounts(String sddl)
at Microsoft.Dynamics.GP.Deployment.Networking.UrlReservationManager.ReservationExists(UrlReservation reservation)
at Microsoft.Dynamics.GP.Deployment.Networking.UrlReservationManager.AddReservation(UrlReservation reservation, Boolean overwrite)
at Microsoft.Dynamics.eConnect.CustomActions.Internal.AddUrlReservation.Immediate()
at Microsoft.Dynamics.Deployment.WindowsInstaller.CustomAction.Begin()
MSI (s) (80!98) [23:37:53:030]: Product: eConnect for Microsoft Dynamics GP 2010 -- Some or all identity references could not be translated.
MSI (s) (80!98) [23:37:53:034]: Closing MSIHANDLE (22) of type 790531 for thread 7064
MSI (s) (80:4C) [23:37:53:060]: Closing MSIHANDLE (17) of type 790542 for thread 6724
MSI (c) (F0:14) [23:37:48:671]: Creating MSIHANDLE (145) of type 790531 for thread 5140
MSI (c) (F0:14) [23:37:53:030]: Closing MSIHANDLE (145) of type 790531 for thread 5140
Some or all identity references could not be translated.
MSI (s) (80:44) [23:37:53:062]: Transforming table InstallExecuteSequence.
MSI (s) (80:44) [23:37:53:062]: Transforming table InstallExecuteSequence.
MSI (s) (80:44) [23:37:53:062]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
Action ended 23:37:53: CA_ConfigureURL. Return value 3.
Action ended 23:37:53: INSTALL. Return value 3.
Property(S): UpgradeCode = {D82ECCB0-F60C-4FDF-BC10-F05D4E7880A6}
Property(S): PATCH = C:\DynamicsVail\MDGP2010_DVD_withHotfixKB2731285_ENUS\AdProd\eConnect\x64\Updates\MicrosoftDynamicsGP11-eConnect-x64-KB2769070-ENU.msp
Property(S): NETFRAMEWORK35 = #1
Here is the list of registered SPNs. I got this from executing:
setspn -L MSDYN
Registered ServicePrincipalNames for CN=MSDYN,CN=Computers,DC=ck,DC=proaudio,DC=com:
MSSQLSvc/MSDYN.ck.proaudio.com
MSSQLSvc/MSDYN.ck.proaudio.com:1433
TERMSRV/MSDYN
TERMSRV/MSDYN.ck.proaudio.com
WSMAN/MSDYN.ck.proaudio.com
WSMAN/MSDYN
RestrictedKrbHost/MSDYN
HOST/MSDYN
RestrictedKrbHost/MSDYN.ck.proaudio.com
HOST/MSDYN.ck.proaudio.com
