January 8, 2009 at 3:14 pm
Hi all,,
well i have some issues with data replication in sql server 2005.
i have two DB server A and B.i am replicating database temp from server A to server B using transcation replication method.
i created publication for database temp on server A.
now restore database temp on server B manually.
now create subscriber for server B.
before replication i check data in database temp on server B which i restored from server A.
after creating everything -- publication,subscriber and distribution database on server A when i go back on server B and check into database temp there were no data in the database.but the original database temp on server A has all data.
now i insert new data into database temp in server A. and go back and check server B..again no data.
so what else should i check..for replication..m i missing anything ..i also check in replication monitor..and its sys error,,,TCP Provider: An existing connection was forcibly closed by the remote host. (Source: MSSQLServer, Error number: 10054)...
so how to reslove this issue...my both server allows remote connection...
pls help me...
thanks,
January 8, 2009 at 4:53 pm
Hi,
I am trying same thing too. But I am getting following error message when I try to create distributor or replication process. Can you please help me out how to resolve this problem. What I am missing? what are the steps. I read articles on it from MSDN but are very vouge and just theorotical. Please help me with this issue.
Property LoginSecure cannot be changed or read after a connection string has been set. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Common.ConnectionSettings.ThrowIfConnectionStringIsSet(String propertyName)
at Microsoft.SqlServer.Management.Common.ConnectionSettings.get_LoginSecure()
at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.InstallDistributor(WizardInputs inputs, Boolean bScripting)
at Microsoft.SqlServer.Management.UI.CreatePublicationWizard.InstallDistributor(IProgress progress, Boolean bScripting, ApplicationException& outerEx, StringBuilder command)
January 8, 2009 at 7:50 pm
Rerun the snapshot job. There's sometimes a handshake issue I've noticed.
January 8, 2009 at 10:27 pm
sqlserverdba76 (1/8/2009)
Hi all,,well i have some issues with data replication in sql server 2005.
i have two DB server A and B.i am replicating database temp from server A to server B using transcation replication method.
i created publication for database temp on server A.
now restore database temp on server B manually.
now create subscriber for server B.
before replication i check data in database temp on server B which i restored from server A.
after creating everything -- publication,subscriber and distribution database on server A when i go back on server B and check into database temp there were no data in the database.but the original database temp on server A has all data.
now i insert new data into database temp in server A. and go back and check server B..again no data.
so what else should i check..for replication..m i missing anything ..i also check in replication monitor..and its sys error,,,TCP Provider: An existing connection was forcibly closed by the remote host. (Source: MSSQLServer, Error number: 10054)...
so how to reslove this issue...my both server allows remote connection...
pls help me...
thanks,
when u setup replication then snapshot agent is run and ur origional data was lost.
January 9, 2009 at 9:11 am
Did you select to 'initialize' your subscription? Sometimes this step can stall if your account does not have sufficient rights on both servers.
Adam Zacks-------------------------------------------Be Nice, Or Leave
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply