Open Forum

GP 2013 Analysis Cubes on SSAS 2016

  • 1.  GP 2013 Analysis Cubes on SSAS 2016

    GOLD CONTRIBUTOR
    Posted Jul 03, 2019 01:57 PM
    Hi, all. I'm running GP 2013 R2 and am trying to install the SSAS cubes on our reporting server, which runs SQL 2016. Does anyone know of a way to install these cubes in SSAS 2016 or have any alternative suggestions... When I try to install in my lab environment, I get the following error...

    ***Fatal Error Encountered***
    Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: Connecting to the Integration Services service on the computer "lab-dev-sql" failed with the following error: "Access is denied."
    By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service.
    ---> System.Runtime.InteropServices.COMException: Connecting to the Integration Services service on the computer "lab-dev-sql" failed with the following error: "Access is denied."
    By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service.
    at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.FolderExistsOnDtsServer(String bstrFolderName, String bstrServerName)
    at Microsoft.SqlServer.Dts.Runtime.Application.FolderExistsOnDtsServer(String sFolderName, String sServerName)
    --- End of inner exception stack trace ---
    at Microsoft.SqlServer.Dts.Runtime.Application.FolderExistsOnDtsServer(String sFolderName, String sServerName)
    at Microsoft.Dynamics.GP.AnalysisCubes.WarehouseDB.CreatePackageFolder()
    at Microsoft.Dynamics.GP.AnalysisCubes.WarehouseDB.CreateDrivers(String companyID, String currency, String exchangetable)
    at Microsoft.Dynamics.GP.AnalysisCubes.fMain.ProcessCompanyMasterPackages()
    at Microsoft.Dynamics.GP.AnalysisCubes.fMain.InstallAnalysisCubesProduct()


    I've confirmed I'm a sysadmin on the instance of SSAS so I think this error is a false flag, but I'm not sure. Thanks in advance for any help.


    ------------------------------
    Jon Godwin
    Database Administrator
    Boulder CO
    ------------------------------
    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role