Jump to content
  • 0

After DB migration to a new SQL server I am getting Permissions issues


Question

Hi All,

 

I have migrated our citrix xendesktop 7.15LTSR db to a new 2022 sql server following 

https://support.citrix.com/article/CTX280675/migrate-citrix-databases-to-new-database-sql-server-cluster-always-on-or-mirroring

&

https://support.citrix.com/article/CTX558936/migrate-citrix-virtual-apps-and-desktop-databases-to-a-new-sql-server

 

All commands completed successfully and I can see on the sql server the controllers are talking to it but when I open studio on any controller. It eventually times out and gives me an error

 

"You do not have the permissions required to complete this request"

 

What did I miss?

Is this because I have used a 2022 SQL server?

 

Thanks

Vince

 

image.thumb.png.a690604f80dae39c7ba63597da108a8b.png

 

Error Id: XDDS:6B8DAD0A

Exception:
    DesktopStudio_PowerShellHistory : GetCapabilitiesScript
    17/07/2023 09:36:07
    
    
    Error Source : Citrix Studio
    
    StackTrace: Citrix.Console.Common.CitrixAggregateException One or more parallel operations failed
       at Citrix.Console.Common.CitrixParallel.InternalForEach[TIn](IEnumerable`1 items, Action`1 operation, Int32 maxSimultaneous)
       at Citrix.Orchestration.Base.PowerShellSdk.CapabilitiesService.Scripts.GetCapabilitiesScript.RunScript()
       at Citrix.Orchestration.Base.PowerShellInteraction.PowerShellScript`1.Run()
       at Citrix.Orchestration.Base.PowerShellSdk.CapabilitiesService.Scripts.GetCapabilitiesAndFeaturesScript.RunScript()
       at Citrix.Orchestration.Base.PowerShellInteraction.PowerShellScript`1.Run()
       at Citrix.Orchestration.Base.PowerShellSdk.CapabilitiesService.PSCapabilitiesService.LoadCapabilities(Boolean servicesAreConfigured, Nullable`1 productEdition, Boolean forceRefresh)
       at Citrix.Orchestration.Base.PowerShellSdk.UpgradeService.UpgradeTasks.DataMigration.DataMigrationTasks.GetUpgradeRequirement(IProgressReporter progressReporter, UpgradeStatusModel upgradeStatusModel)
       at Citrix.Orchestration.Base.PowerShellSdk.UpgradeService.UpgradeTasks.UpgradeTaskBase.AssessUpgradeRequirement(IProgressReporter progressReporter, UpgradeStatusModel upgradeStatusModel)
       at Citrix.Orchestration.Base.PowerShellSdk.UpgradeService.UpgradeTasks.Upgrade.GetUpgradeRequirement(IProgressReporter progressReporter, UpgradeStatusModel upgradeStatus)
       at Citrix.Orchestration.Base.PowerShellSdk.UpgradeService.UpgradeTasks.UpgradeTaskBase.AssessUpgradeRequirement(IProgressReporter progressReporter, UpgradeStatusModel upgradeStatusModel)
       at Citrix.Orchestration.Base.PowerShellSdk.UpgradeService.PSUpgradeService.GetUpgradeStatus(IProgressReporter progressReporter)
       at Citrix.Orchestration.Base.PowerShellSdk.SiteService.Scripts.LoaderScript.RunScript()
       at Citrix.Orchestration.Base.PowerShellInteraction.PowerShellScript`1.Run()
       at Citrix.Console.DeliveryCenter.UI.ViewModel.DesktopStudioViewModel.LoadSiteState(IProgressReporter progressReporter)
       at Citrix.Console.DeliveryCenter.UI.ViewModel.DesktopStudioViewModel.ClassicConnectToSite(String ccsLocation, Boolean safeForDispatcher, IProgressReporter progressReporter)
       at Citrix.Console.DeliveryCenter.UI.ViewModel.DesktopStudioViewModel.ConnectToSite(String ccsLocation, Boolean safeForDispatcher, IProgressReporter progressReporter)
       at Citrix.Console.Common.OperationTimer.TimeBlock(Action operation)
       at Citrix.Console.CommonControls.ProgressDisplay.GenericProgressOperationWithFeedBack.PerformOperationInternal()
       at Citrix.Console.CommonControls.ProgressDisplay.ProgressWindowOperation.PerformOperation()
       at Citrix.Console.CommonControls.ProgressDisplay.ProgressWindowViewModel.PerformAction(Action operationComplete)
    
Inner Exception:
    
    StackTrace: Citrix.Console.Common.CitrixAggregateException One or more parallel operations failed
       at Citrix.Console.Common.CitrixParallel.InternalForEach[TIn](IEnumerable`1 items, Action`1 operation, Int32 maxSimultaneous)
       at Citrix.Orchestration.Base.PowerShellSdk.CapabilitiesService.Scripts.GetCapabilitiesScript.GetCapabilities(DeploymentCapabilitiesModel siteCapabilities, SdkType type, Reduce reduce, Fetch fetch, IEnumerable`1 controllersAtMinVersion)
       at Citrix.Orchestration.Base.PowerShellSdk.CapabilitiesService.Scripts.GetCapabilitiesScript.<>c__DisplayClass9_0.<RunScript>b__2(CapabilityConfig kv)
       at Citrix.Console.Common.CitrixParallel.<>c__DisplayClass5_2`1.<InternalForEach>b__0(Object arg)
    
Inner Exception:
    DesktopStudio_ErrorId : AccessDenied
    Error Source : CitrixBrokerService
    ErrorCategory : PermissionDenied
    DesktopStudio_PowerShellHistory : SimplePowerShellScript
    17/07/2023 09:36:07

Link to comment

1 answer to this question

Recommended Posts

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...