0

I have installed SQL Server 2019 RC1 and cannot create a snapshot. I keep getting the same message when I run the snapshot agent:

2019-10-30 12:32:41.59 Microsoft (R) SQL Server Snapshot Agent
2019-10-30 12:32:41.59 [Assembly Version = 15.0.0.0, File Version = 15.0.1900.25]
2019-10-30 12:32:41.59 Copyright (c) 2016 Microsoft Corporation.
2019-10-30 12:32:41.59 The timestamps prepended to the output lines are expressed in terms of UTC time.
2019-10-30 12:32:41.59 User-specified agent parameter values:
2019-10-30 12:32:41.59 --------------------------------------
2019-10-30 12:32:41.59 -Publisher DB100
2019-10-30 12:32:41.59 -PublisherDB REF3_DB
2019-10-30 12:32:41.59 -Publication REF3_PDR4
2019-10-30 12:32:41.59 -Distributor DB100
2019-10-30 12:32:41.59 -DistributorSecurityMode 1
2019-10-30 12:32:41.59 -XJOBID 0xA694274CD89FAF418C8B059F22C01B85
2019-10-30 12:32:41.59 --------------------------------------
2019-10-30 12:32:41.59 Connecting to Distributor 'DB100'
2019-10-30 12:32:41.64 Parameter values obtained from agent profile:
2019-10-30 12:32:41.64 ---------------------------------------------
2019-10-30 12:32:41.64 -BcpBatchSize 100000
2019-10-30 12:32:41.64 -HistoryVerboseLevel 2
2019-10-30 12:32:41.64 -LoginTimeout 15
2019-10-30 12:32:41.64 -QueryTimeout 1800
2019-10-30 12:32:41.64 ---------------------------------------------
2019-10-30 12:32:41.64 Validating Publisher
2019-10-30 12:32:41.64 Connecting to Publisher 'DB100'
2019-10-30 12:32:41.65 Publisher database compatibility level is set to 150.
2019-10-30 12:32:41.65 Retrieving publication and article information from the publisher database 'DB100.REF3_DB'
2019-10-30 12:32:41.65 [0%] Locking published tables while generating the snapshot
2019-10-30 12:32:41.67 [0%] The replication agent had encountered an exception.
2019-10-30 12:32:41.67 Source: Replication
2019-10-30 12:32:41.67 Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentException
2019-10-30 12:32:41.67 Exception Message: An unspecified error had occurred in the native SQL Server connection component.
2019-10-30 12:32:41.67 Message Code: 55012
2019-10-30 12:32:41.67
  • As you already configured Publisher, Distributor - please set up a Subscriber (or maybe you did already) -- Did a quick google search for MSSQL 55012 - and your subcontext of "connection problem" ... The suggestions from original MSDN sites point towards DLLs with conflicting versions .. – eagle275 Oct 30 '19 at 13:49
1

In my case, I had the same error message. My error was that I had installed my new server (Windows 2019 Std) in English (Canada) and that when I updated the Snapshot via the agent, I always had the error "An unspecified error had occurred in the native SQL Server connection component. ".

To correct the problem, I reinstalled my server in English (United States) and everything worked afterwards.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.