Viewing 4 posts - 1 through 5 (of 5 total)
There was an issue with the linked server that had caused this error. The user is fully permissioned as sa so no security issue.
Am now able to remotely execute...
January 14, 2014 at 7:41 am
Kerberos authentication is now working - verified by querying sys.dm_exec_connections
EXEC [LinkedServer].[SSISDB].[catalog].[create_execution] @package_name=N'Package.dtsx', @execution_id=@execution_id OUTPUT, @folder_name=N'Test', @project_name=N'ETLMaster', @use32bitruntime=False, @reference_id=Null
Select @execution_id
DECLARE @var0 smallint = 1
EXEC [LinkedServer].[SSISDB].[catalog].[set_execution_parameter_value] @execution_id, @object_type=50, @parameter_name=N'LOGGING_LEVEL', @parameter_value=@var0
EXEC [LinkedServer].[SSISDB].[catalog].[start_execution]...
January 13, 2014 at 10:09 am
Still trying to get the network guys engaged to sort add the SPN entries.
In the meantime could someone pls confirm whether the double hop issue can be resolved using SQL...
January 10, 2014 at 9:46 am
Hi Journeyman, Both Server A and B have enabled 'trust this computer for delegation to any service'
and the domain account enabled as 'Account is trusted for delegation'
How else can I...
December 31, 2013 at 3:32 am
Viewing 4 posts - 1 through 5 (of 5 total)