November 24, 2015 at 10:16 am
Hi Experts getting below error while while running linked server. It is breaking randomly.
can any one guild from where I can start looking.
Deletion Completed
HResult 0x1B, Level 16, State 1
Registry information is corrupt or missing. Make sure the provider is installed and registered correctly.
EXEC [FASQL-SIT1].[facets_db].dbo.tzg_dmu_bulk_copy '[facets_db].dbo.BPA_RLTD_RTYP_D', 'FASQL-CFG1', 'facets_cmu_db', 'dbo.tzgt_dmut_6366_t1_add', '0'
Starting Table 1 Insert at 08:21:33.4
OLE DB provider "SQLNCLI11" for linked server "FASQL-CFG1" returned message "Client unable to establish connection".
OLE DB provider "SQLNCLI11" for linked server "FASQL-CFG1" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
INSERT INTO [facets_db].dbo.BPA_RLTD_RTYP_D SELECT * FROM [FASQL-CFG1].[facets_cmu_db].dbo.tzgt_dmut_6366_t1_add
Thanks in advance for your help.
November 24, 2015 at 2:31 pm
Can any one help or have seen this issue before ?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply