sqlserver2019发布订阅的MSSQL_REPL55012错误处理

发布于:2024-12-18 ⋅ 阅读:(16) ⋅ 点赞:(0)

利用SQL2019进行发布时报如下错误
Message: An unspecified error had occurred in the native SQL Server connection component.
Stack:    在 Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)
   在 Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowConnectionFailureException(CConnection* pNativeConnectionWrapper)
   在 Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.InitializeNativeBcpOutProvider(LogMessageCallback logMessageCallback, String strName, String strApplication, String strHost, String strServer, String strNetwork, Int32 encryptionLevel, String strDatabase, SecurityMode securityMode, String strLogin, SecureString strPassword, Int32 bcpBatchSize, Int32 loginTimeout, Int32 queryTimeout, Int32 packetSize, DeadlockPriority deadlockPriority, String strRowDelimiter, String strFieldDelimiter, Byte syncMethod, Boolean forceOdbcBcp, Boolean forceOleDbBcp, Boolean enableMultipleActiveResultSets, Boolean useReadPastHint, Boolean usePageLockHint, Boolean securePassword)
   在 Microsoft.SqlServer.Replication.Snapshot.TransSnapshotProvider.InstantiateBcpOutProviderWorker(String strBcpConnectionName)
   在 Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.InstantiateBcpOutProvider(String strBcpConnectionName)
   在 Microsoft.SqlServer.Replication.Snapshot.SqlServer.BcpOutThreadProvider.Initialize()
   在 Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc()
   在 Microsoft.SqlServer.Replication.MainWorkerThread.AgentThreadProc()
   在 Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper() (源: MSSQL_REPL,错误号: MSSQL_REPL55012)
获取帮助: http://help/MSSQL_REPL55012

处理方式:
复制此文件:C:\Windows\SysWOW64\1033\msoledbsqlr.rll
到:C:\Program Files\Microsoft SQL Server\150\COM

再建发布任务后,复制监视器就正常了。