HTTP could not register URL http://+:8000/SyncServices/. Your process does not have access rights to this namespace. Access is denied

The following error occurred when trying to start the Dynamics AX 2008 Synchronization Service:

—ERROR MESSAGE—
An error occurred while starting the synchronization service

—MORE DETAILS—
HTTP could not register URL http://+:8000/SyncServices/. Your process does not have access rights to this namespace (see http://go.microsoft.com/fwlink/?LinkId=70353 for details).
Access is denied

—STACK TRACE—
   at System.ServiceModel.Channels.SharedHttpTransportManager.OnOpen()
   at System.ServiceModel.Channels.TransportManager.Open(TransportChannelListener channelListener)
   at System.ServiceModel.Channels.TransportManagerContainer.Open(SelectTransportManagersCallback selectTransportManagerCallback)
   at System.ServiceModel.Channels.HttpChannelListener.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel.Dispatcher.ChannelDispatcher.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel.ServiceHostBase.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at Microsoft.Dynamics.SyncServices.SyncServiceBase.OnStart(String[] args)

As explained in article 70353, the workaround is to run the following command on the server:

netsh http add urlacl url=http://+:8000/SyncServices user=[domain][User]

The Dynamics AX Object Server 5.0 service terminated with service-specific error 80 (0x50)

When attempting to start the AOS Service after changing the Log on, the following error appeared:

Windows could not start the Dynamics AX Object Server 5.0$01-[Application] on [Server].  For more information, review the System Event Log.  If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 80.

System Event Log:

The Dynamics AX Object Server 5.0$01-[Application] service terminated with service-specific error 80 (0x50).

This occurred regardless of any database permissions.  The workaround was to apply the following permissions to the following folders:

  • %ProgramFiles%Microsoft Dynamics AX50ApplicationAppl[Application]
    • Modify, Read & execute
    • List folder contents
    • Read
    • Write
  • %ProgramFiles%Microsoft Dynamics AX50Server[Application]Log
    • Read
    • Write

While the AOS Service was down, the following error got written into the Application log each second:

Microsoft Dynamics AX Business Connector Session 7.
RPC error: RPC exception 1722 in Ping occurred in session 50

Installing Sql Server 2008 and Dynamics AX 2009 on Windows Server 2008 x64

Following the Microsoft Dynamics AX 2009 System Requirements and the Microsoft Dynamics AX 2009 Installation guide, I installed Dynamics 2009 and Sql Server 2008 on Windows Server 2008 x64 SP1 for Analysis Services, Reporting Services, Workflow and the Enterprise Portal.

  • Following is a list updates and programs that were already installed on the server:
    KB940518,KB938464,KB942288,KB948609,KB948610,KB949189,KB950050,KB950760,KB950762,KB950974,
    KB951066,KB951698,KB951978,KB952287,KB953733,KB954459,KB955020,KB955069,KB955302,KB955839,
    KB956802,KB956841,KB957097,KB957200,KB957321,KB957388,KB958481,KB958483,KB958623,KB958624,
    KB958644,KB958687,KB958690,KB959130,KB960225,KB960715,KB961260,Microsoft .NET Framework 3.5 SP1
  1. Added role “Web Service (IIS)” for the the Enterprise Portal with ASP.NET, ISAPI Extensions, ISAPI Filters, .NET Extensibility, using the default role services and add the server to the list of trusted sites in IE.
  2. Installed SQL Server 2008with “database engine services”, “analysis services” and “reporting services and management tools – complete”, using the native mode default configuration.
    • This installed the following programs:
      • SQL Server System CLR Types
      • Microsoft Visual Studio Tools for Applications 2.0
      • Microsoft SQL Server VSS Writere
      • Microsoft SQL Server Compact 3.5 SP1 Query Tools
      • Microsoft SQL Server Compact 3.5 SP1
      • Microsoft SQL Server 2008 Setup Support Files
      • Microsoft SQL Server 2008 Policies
      • Microsoft SQL Server Native Client
      • Microsoft SQL Server 2008 (64-bit)
      • Microsoft Office 2003 Web Components
    • This installed the following updates:
      • KB946040,KB946308,KB946344.KB947540,KB947789,Office 2003 Web Components Service Pack 1 (SP1) for the 2007 Microsoft Office System
  3. Installed SQL Server 2008 Service Pack 1 – CTP
    • This installed the following updates and programs
      • Service Pack 1 for Microsoft SQL Server 2008 Browser (KB959337)
      • Service Pack 1 for Microsoft SQL Server VSS Writer (64-bit)(KB959337)
      • Service Pack 1 for SQL Server 2008 (KB959337)
      • Service Pack 1 for SQL Server System CLR Types (64-bit)(KB959337)
      • Microsoft SQL Server 2008 Browser
  4. Installed Microsoft Analysis Management Objectsfor Analysis Services
    • This installed the following programs
      • Microsoft SQL Server 2008 Analysis Management Objects
  5. Run IE as Administrator, go to http://localhost/Reports and give the current user administrator permissions the site and “Content Manager” rights to the root folder.  This prevents the following error when viewing the page:

    The
    permissions granted to user ‘mydomainmyAccount’ are insufficient for
    performing this operation. (rsAccessDenied) (ReportingServicesLibrary)

  6. Restored the Dynamics AX demo data
  7. Installed Visual Studio 2008 Shell (isolated mode) with Service Pack 1for reporting extensions and the Enterprise Portal
    • This installed the following programs and updates
      • Update for Microsoft Visual Studio Web Authoring Component (KB945140)
      • Hotfix for Office (KB950278)
      • Hotfix for Microsoft Visual Studio 2008 Shell (isolated mode) – (KB946040)
      • Hotfix for Microsoft Visual Studio 2008 Shell (isolated mode) – (KB946308)
      • Hotfix for Microsoft Visual Studio 2008 Shell (isolated mode) – (KB946344)
      • Hotfix for Microsoft Visual Studio 2008 Shell (isolated mode) – (KB946581)
      • Hotfix for Microsoft Visual Studio 2008 Shell (isolated mode) – (KB947173)
      • Hotfix for Microsoft Visual Studio 2008 Shell (isolated mode) – (KB947540)
      • Hotfix for Microsoft Visual Studio 2008 Shell (isolated mode) – (KB947789)
    • This installed the following programs
      • Visual Studio 2008 Shell Isolated Mode Redistributable Package
      • Microsoft Visual Studio Web Authoring Component
      • Microsoft Visual Studio Shell 2008 Service Pack 1
      • Microsoft Visual C++ 2008 Redistributable – x86 9.0.20729
  8.  Installed the .Net Developer Tools from the Windows SDK for Windows Server 2008 and .NET Framework 3.5

    • This installed the following programs
      • Microsoft Windows SDK for Windows Server 2008 (6001.18000.367)
      • Microsoft Visual C++ 2008 Redistributable – x64 9.0.21022
    • Installing this prevents the following error when deploying the reports:

      The following components have not been installed or are not configured correctly.
      AL.exe
      Microsoft Domain-specific Langugage Tools…

       

  9.  Do step one in article KB 957312
  10.  Installed Dynamics AX 2009 with Application files, AOS, Client and the .NET Business Connector

    • This installs the following programs
      • DHTML Editing Component
      • Microsoft Visual C++ 2005 Redistributable
      • Microsoft SQL Server 2005 Native Client
      • Microsoft Dynamics AX 2009 Client Help Files
      • Microsoft Dynamics AX 2009 Components (64 bit)
      • Microsoft Dynamics AX 2009 Object Server (64 bit)
  11. After the AOS service completed its tasks, installed the Service Pack 1 for Microsoft Dynamics AX 2009
    • This installs the following programs
      • Service Pack 1 for Microsoft Dynamics AX 2009 Components (64 bit)(KB956568)
      • Service Pack 1 for Microsoft Dynamics AX 2009 Object Server (64 bit)(KB956568)

     

  12. Compile application, detect code upgrade conflicts and synchronize database.
  13. Install Dynamics AX Reporting Tools
    • This installs the following program
      • Microsoft SQL Server 2005 ADOMD .Net
    • With the isolated shell installed, a popup with the following error appeared: “Invalid license data.  Reinstall is required”.  After clicing on OK, everything seemed to be fine.  However, when I tried the same with Microsoft Visual Studio Shell (integrated mode)(KB 945140) instead, the popup error didn’t appear.
  14.  Do step two in article KB 957312
    • This installs the following updates and programs
    • Reporting tools installed sucessfully but the Enterprise Portal installed with a warning due to an InvalidOperationException
  15. In article KB 957312under step three, match the Reporting Services Execution Account with the .NET Business Connector proxy account. The rest is optional because it is already done with the Dynamics AX 2009 SP1.
  16. Optional: disable the User Account Control as described in the Microsoft Dynamics AX 2009 Installation guide.  This is not necessary the first time that reports are deployed. However, if one attempts to deploy reports again and this option is checked, then the deploy will cancel with the following error:
    Error: Deployment failed unexpectedly with the message:

    See the log file for further details.

    Deployment failed with the following exception:

    System.Runtime.InteropServices.COMException (0x80040208)

       at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)

       at System.Management.ManagementObject.Initialize(Boolean getObject)

       at System.Management.ManagementBaseObject.get_Properties()

       at System.Management.ManagementBaseObject.GetPropertyValue(String propertyName)

       at Microsoft.Dynamics.Framework.Deployment.Reports.SrsWmi.get_ConfigPath()

       at
    Microsoft.Dynamics.Framework.Deployment.Reports.ReportLibraryDeployer.DeployBusinessLogicAssemblies(IEnumerable`1
    businessLogicAssemblies, DeploymentLogger logger)


       at
    Microsoft.Dynamics.Framework.Deployment.Reports.ReportLibraryDeployer.Deploy(IEnumerable`1
    reportLibrariesToDeploy, IEnumerable`1 transitiveReferenceClosure,
    IEnumerable`1 cultures, DeploymentLogger logger, Func`2
    connectionStringModifier)
  17. Run the “Microsoft Dynamics AX Reporting Project Deployment” and deploy all of the report libraries needed. No matter what I tried, the following error was written to the log:
    …Could not load file or assembly ‘Microsoft.Dynamics.AX.Fim.PaymentService, Version=5.0.0.0… Microsoft.Dynamics.Framework.Deployment.Portal… Microsoft.Dynamics.Framework.Workflow.Communication… Microsoft.Dynamics.Kernel.Client… Microsoft.Dynamics.ReportingServices… Microsoft.Dynamics.RfidProxy… Microsoft.Dynamics.SysImport… Microsoft.Dynamics.TeamFoundationServerProxy…
  18. Run Dynamics to view the Role Center, view it in IE at http://%5Bserver%5D/sites/DynamicsAx or wherever it was installed.  Run a report, such as
    CustSRS.CustsalesOpenOrders_NA.AutoDesign
  19. Deploy ODC filesand view it at http://%5Bserver%5D/sites/DynamicsAx/Data%20Connections/Forms/AllItems.aspx
  20. Install Analysis extensions and Workflow.  Be sure to install it in SharePoint rather than the Default Web Site.  Setup completed with the following message:
    WARNING: Setup could not validate that the ASP.NET version on virtual directory ‘MicrosoftDynamicsAXWorkflow50’ was changed.
  21. Validate that the Workflow works with the Workflow infrastructure configuration wizard

That’s all folks!

 

The dimension ‘[ComputerAdministrator]’ was not found in the cube when the string, [ComputerAdministrator], was parsed. The END SCOPE statement does not match the opening SCOPE statement.

This error occurred the first time that I tried to compile the project "FoodMart 2008".  To get around this, I ran the following script to create an entry in the Employee table for me, as described in this thread: http://www.sqlservercentral.com/Forums/Topic352574-17-1.aspx

INSERT INTO [FoodMart 2008].[dbo].[employee]
           ([employee_id]
           ,[full_name]
           ,[first_name]
           ,[last_name]
           ,[position_id]
           ,[position_title]
           ,[store_id]
           ,[department_id]
           ,[birth_date]
           ,[hire_date]
           ,[end_date]
           ,[salary]
           ,[supervisor_id]
           ,[education_level]
           ,[marital_status]
           ,[gender]
           ,[management_role]
           ,[user_name])
SELECT
           3
           ,’First Last’
           ,’First’
           ,’Last’
           ,position_id
           ,position_title
           ,store_id
           ,department_id
           ,birth_date
           ,hire_date
           ,end_date
           ,salary
           ,supervisor_id
           ,education_level
           ,marital_status
           ,gender
           ,management_role
           ,’ComputerAdministrator’
FROM [FoodMart 2008].[dbo].[employee]
WHERE employee_id = 2

Extracting files from an msi

msiexec /a PathToMSIFile /qb TARGETDIR=DirectoryToExtractTo