.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Replication Setup Error

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server


I'm setting up replicaiton between two MS SQL 2008 servers and I'm having issues getting the snapshop at the publisher to work.  I get the following message:

 The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active.

I have created a windows account on the network, provided that account with admin rights and I have changed agent to use this account to run.  Repldata has been shared and I provied that created account with full rights to that folder.  That account also has the db_owner rights on the DB that I am trying to replicate. 

Am I missing a step? What might be the issue here?



View Complete Post

More Related Resource Links

error occurred while I tried to setup transaction replication with updateable subscription

   when I tried to setup transactional replication with updatable subscriptions between two nodes, an error occurred.

The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "REPL1 " was unable to begin a distributed transaction. Changed database context to 'database1'.

OLE DB provider "SQLNCLI" for linked server "REPL1" returned message "No transaction is active.". (.Net SqlClient Data Provider)
 May I know whether in order to setup transactional replication, do I need to run replication agents under domain users or local users?

thank you

Error for logread.exe and distrib.exe when I setup Peer-to-peer replication



I am in engineering design field and fairly new to SQL server. One of our applications use SQL server 2005.

I have setup Peer-to-peer replication. As soon as replication setup is completed, I start getting error for logread.exe and distrib.exe on satellite server (this is in India).

I get below error (same for logread.exe):

Distrib.exe Application Error , Application failed to initialize properly(0xx0000142)click ok to terminate the application

I have tried hard to resolve this issue but no success. I have deleted the replication many times and tried recreating but still no success.

user id I have used for Snapshot agent, log read agent has enough DBO permissions on both servers.

Please if someone can help me resolving this issue.

Best Regards,

Kshitij Nanavaty

How to overcome .net download error during setup

Hello All,We have a .NET 3.5 SP1 WPF application that we deploy to our costumers using a setup and deployment project in Visual Studio.In order to make things easier to our costumers, we provide in a specifc URL path for the setup.exe file and the .msi file.As the .net 3.5 is a prerequisite for the app to run, the setup.exe properly detects when it is missing form the costumer PC and ask to start the instalation.This works fine for most of our costumer, but, for some of them, the download fails with the following message:An error occurred downloading the following resource:http://go.microsoft.com/fwlink/?LinkId=37283 (something similar to this path).I suspect that some costumer have firewalls or anti-virus programs that block file download trought a non autorized program.Most of our costumer have dificulties to install the application and they actually don´t know anything about internet security or deployment process, so they expect the installtion to be an easy process.I would like top hear from you could be really causing this and how do you suggest to workaround this issue, so the user don't have to bother about prerequisites instalation.Kindly Regards,Igor.Project Manager at INOVATIVA Tecnologia www.inovativatec.com

Net Framework 1.0 Error 1904 during setup mscoree.dll H-result 2146232576

I cleaned off all my .Net framework files with the .Net framework cleaner. I then started at 3.5, installed it, went well, installed 3.0, went well, installed 2.0, went well, installed 1.1, went well, then, tried to install 1.0 redistribution package for my windows xp home and it stopped at almost the very end saying ERROR installing 1.0 ERROR 1904 system32\mscoree.dll failed to register. H-result 2146232576. I tried renaming it and installing the 1.0 again but still get the same error. i tried using the IGNORE option, it said it installed but i know the mscoree.dll isn't working. i used the installer cleanup tool also to no avail. i deleted the URTTemp folder and tried a reinstall. This didn't work either. Anyone know what I might can do to get this corrected? I have not done anything myself in the registry. I have used RegCure and registry mechanic but Net Framework 1.0 still gave the error when I tried to install. Any help appreciated. I did read something about 1.1, 2.0,3.0 or 3.5 might have a newer mscoree.dll file and that night be why I can't register the one I have. I need the 1.0 version 3705 though as one of my programs uses it. Also, i am now not able to put any of the updates on my computer. it downloads them but they fail to install. Example, net framework 2.o service pack 2, net framework 3.5 service pack 1, and net framework 3.5 family update. Thanks....

Error in Replication: connection was chosen as the victim in a deadlock

I'm using a merge replication with SQL 2008 at server and SQL Express 2008 on subscribers. We are using around 100 subscribers. I'm getting the following error once two subscribers replicate at the same time. The final number of transaction uploaded to the server is always arong 100 and a similar number in the downloads, so the amount of transaction is not an issue. I'he been playing with the merge profile with no luck. The merge process could not replicate one or more INSERT statements to the 'Publisher'. A stored procedure failed to execute. Troubleshoot by using SQL Profiler. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200990) Get help: http://help/MSSQL_REPL-2147200990 A query executing on Publisher 'xxxxx' failed because the connection was chosen as the victim in a deadlock. Please rerun the merge process if you still see this error after internal retries by the merge process. (Source: MSSQLServer, Error number: 1205) Get help: http://help/1205 Any idea? This is getting to a critical point where transactions are not being uploaded to the server.  Additonally, there are a lot of blocks between the subscribers, and they are mainly associated with table MSmerge_partition_groups  

SQL Server Installation error. setup.rll

Hi, I am coming to you folks for some help on this issue that has been baffling me. Installing SQL Server 2008 R2 on a Windows Server 2008 R2 generates the same error every time ( "SQL Server 2008R2\Resouces\1033\Setup.rll is either not designed to run on Windows or it contains an error tryinstalling the program again using the original installation media." Then when I click on OK (From the error box) I get the following message: SQL Server MEdia does not support the language of the OS or doewn't have an ENU lcalized files. Use the matching language specific SQL. I am using a full version of both Windows Server and SQL Server.  

SQL server setup has encountered the following error: The given key was not present in the dictionar

For various reasons I have installed and uninstalled SQL Server 2008 developer on my vista machine.. I just received this error after clicking the installation > New SQL Server stand alone installation ....link in the Installation Center SQL server setup has encountered the following error: The given key was not present in the dictionary I had to uninstall and reinstall because the analysis services install failed so I wanted to reinstall.

XML Column containing single quote causes replication error

We have SQL Server 2005 transactional replication set up, and some of our tables have XML datatype columns.  We have run into an issue with the following error in the publication: Incorrect syntax near 's'. (Source: MSSQLServer, Error number: 102) Get help: http://help/102 Looking at the distribution database, I was able to extract the offending command, and it turns out that the XML column has a single quote (') embedded in it, and the command that was generated for inserting the row into the subscriber table has bad syntax because of the single quote (i.e., it is not escaped).  One interesting note is that the single quote happens to also show up in a non-XML column, and the command segment for that column was generated correctly (it was escaped). Is there a workaround / solution for this?

SQL 2008 R2 setup failover error

Hi, I try to setup setup an SQL 2008 R2 failover cluster on two Windows 2008 R2 servers with clustering enabled. In the setup wizard I have selected to install all options. After that the installation process is running, but after 5 minutes I receive an error windows with the tekst below. The following error has accourred: An error occourred during the installation of assembly 'Microsoft.DataTransformationServices.Controls,fileVersion="10.50.1600.1",version='",c ulture="neutral",publicKeyToken="89845DCD8080CC91",prosessorArchitecture="MSIL", The signature or catalog could not be verified or is not valid. In the SQL setup windows I can see that everything is installed exept the Database Engine Services, the SQL Server Replication and Full-Tekst Search Can you give me some advice how to solve this issue. Thanks in advance. Kind Regards, hensl

error in merge replication

Hi ALL,      I have merge replication configured between republishers( sql 2008) and subscribers( sql 2000)...i am getting the following error while trying to sync   The merge process could not update the list of subscriptions. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201010) Get help: http://help/MSSQL_REPL-2147201010 Cannot insert duplicate key row in object 'dbo.sysmergesubscriptions' with unique index 'uc1sysmergesubscriptions'. (Source: MSSQLServer, Error number: 2601) Get help: http://help/2601 The subscription could not be created. (Source: MSSQLServer, Error number: 14057)   Any suggestions y i am getting this error TIA

Sharepoint Setup Error

I am installing MOSS2007 on Server 2008 and am receiving the following errors in my application log: Error1: Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (0e3d32ba-5963-4d69-85bd-9857b945dc8b). Reason: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) Techinal Support Details: System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) at Microsoft.Office.Server.Search.Administration.SearchApi.RunOnServer[T](CodeToRun`1 remoteCode, CodeToRun`1 localCode, Boolean useCurrentSecurityContext, Int32 versionIn) at Microsoft.Office.Server.Search.Administration.SearchApi.AddApp(Role role) at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.InstallGathererApplicationIf() at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.Synchronize() at Microsoft.Office.Server.Administration.ApplicationServerJob.ProvisionLocalSharedServiceInstances(Boolean isAdministrationServiceJob)   Error 2: Error backing up registry hive to the configuration database. Context: Application 'SharedServices1' Details: Access is denied. (0x80070005)   Warning: Could not import the registry hive into the registry because it does not exist in the configuration database. Context: Application 'bd62e31e-3dcb-4

Setup Error during Installation progress

Version: Enterprise Evaluation OS: 7   Attempting to install the Enterprise Evaluation edition during the installation process, I get the following error "The name is already in use as either a service name or a service display name". No other name is in use. I've uninstalled and re-installed and no success. I've remove the folder from registry and still no success, I get the same error Can someone help, please?

SQL Server 2008 Express Setup failure: Unknown Property Error

I am trying to install SQL server 2008 on windows 7 but it returns the following error when almost done with installation: TITLE: SQL Server Setup failure. ------------------------------ SQL Server Setup has encountered the following error: Unknown property. . ------------------------------ BUTTONS: OK ------------------------------   Can someone please assist me with this, I have tried for more than a week to go around it. I have also searched online for solutions but in vain. Looking into the log files, I see these: 2010-09-05 21:04:41 Slp: Running Action: Install_SqlBrowser_Cpu32_Action 2010-09-05 21:04:41 Slp: Target package: "C:\Softwares\Database and Management\SQLEXPRADV_x86_ENU\x86\setup\sqlbrowser.msi" 2010-09-05 21:04:46 Slp: InstallPackage: MsiInstallProduct returned the result code 0. 2010-09-05 21:04:46 Slp: RunMsiCore succeeded. 2010-09-05 21:04:46 Slp: Checkpoint: INSTALL_SQLBROWSER_CPU32_ACTION 2010-09-05 21:04:46 Slp: Completed Action: Install_SqlBrowser_Cpu32_Action, returned True 2010-09-05 21:04:46 Slp: ---------------------------------------------------------------------- 2010-09-05 21:04:46 Slp: Running Action: Install_SqlSqmShared_Cpu32_Action 2010-09-05 21:04:47 Slp: Error: Action "Install_SqlSqmShared_Cpu32_Action" threw an exception during execution. 2010-09-05 21:04:47 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExec

Setup error installing SQL 2008 Developer on Windows 7 RTM

When trying to install SQL 2008 on Windows 7 (RTM), I get a dialog after launching setup with:Invoke or BeginInvoke cannot be called on a control until the window handle has been created.I rebooted and tried a second time with same results.The Bootstrap log contains this Detail_LandingPage.txt file.Any ideas?Detail_LandingPage.txt2009-08-09 19:31:00 Slp: Log provider 'Microsoft.SqlServer.Chainer.Infrastructure.LogProviderFile' has been registered2009-08-09 19:31:00 Slp: Log provider 'Microsoft.SqlServer.Chainer.Infrastructure.LogProviderStatus' has been registered2009-08-09 19:31:00 Slp: Reading XML resource 'Microsoft.SQL.Chainer.PackageData.Package.xml'2009-08-09 19:31:00 Slp: Reading schema resource 'Microsoft.SQL.Chainer.Package.Package.xsd'2009-08-09 19:31:01 Slp: Document 'Microsoft.SQL.Chainer.PackageData.Package.xml' validated with schema 'Microsoft.SQL.Chainer.Package.Package.xsd' has been successfuly loaded into datastore path '/Datastore/Package'2009-08-09 19:31:01 Slp: ----------------------------------------------------------------------2009-08-09 19:31:01 Slp: Running Action: ReadProductXML2009-08-09 19:31:02 Slp: Reading XML resource 'Microsoft.SQL.Chainer.Product.Product.xml'2009-08-09 19:31:02 Slp: Reading schema resource 'Microsoft.SQL.Chainer.Product.Product.xsd'2009-08-09 19:31:02 Slp: Document 'Microsoft.SQL.Chainer.Product.Product.xml'

Replication Error - Can't Insert Null into MSSubscription_agents.allow_subscription_copy

In attempting to set up a transactional replication subscription via the UI, I keep getting the error that I cannot insert a Null into the MSSubscription_agents table.  Originally, this was on the allow_subscription_copy column.  One resource suggested altering the column to allow Nulls but that only moved the issue to the attach_state and, later, attach_version columns.  My immediate issue was resolved with these changes BUT I'm really concerned that I need to alter a system table in order to allow a fairly simple replication subscription to be configured.  Has anyone run into this issue and is there a better work around available? I'm running SQL 2008 Enterprise Edition SP1 in a 64-bit environment on both the Publisher/Distributor and Subscriber servers.

report error replication sql 2008

In 2000 sql error occurred when the replications showed the line and record with, exactly what record. As I see it in sql 2008?

Replication : Error: subscription already exists

I am receiving an error when i try to recreate a subscription. Error: subscription already exists. I ran expired subscription clean up job but still received this error. what am i missing?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend