I got this error: "A .NET Framework error occurred during execution of user-defined routine or aggregate "sp_scriptdropdelreconciliationproc_sqlclr": System.Data.SqlClient.SqlException: The locale identifier (LCID) 8192 is not supported by SQL Server. "
Sir, I have a question. If an organization have multiple branches and each branch have local server. But main central database server is placed an another place e.g Headoffice. So what is a solution to update all clients data to each other on each transaction and also update main central server. and central server also have two server one is live and one is for backup. Thanks in advance.
Hi Manzoor very good presentation. If i want to extend replication how can i do. I means. i have replication tableA last 2 month. now i want to replication to another tableB and tableC. How can Update?
Hi Manzoor, Prodcution standard edition 2012 (publisher) and report server 2016 web edition(subscriber) is this environment eligible for replication? (snapshot and tran repl) Please suggest
hey friend, At last it gives me this error how to solve it... An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ No active subscriptions were found. The publication must have active subscriptions in order to post a tracer token. (Microsoft SQL Server, Error: 21488)
Hi, I was trying to setup replication. So i went ahead and configured my distributor and then carried on with my Publisher configuration. Once i finished up with the publisher i tried starting the snapshot and log reader agents. I get a red cross on my server in the monitoring screen and this is the eror message i get: Login failed for user 'NT Service\SQLAgent$MSSQLSERVER3'. I know this is something related to the DB roles as db ownership but i am unable to solve this issue. Please help Thanks
Najeeb - I know your post is over 6 months old but I just saw your question. Here's how I solved a similar issue like you described. Go into the properties of your database and select the "Files" selection in the left hand pane; then ensure there is an "Owner" set for the files. Mine was blank on both the Publisher and Subscriber and once I set them the issue was resolved. BTW I set the owner on both to [sa]. Hope this helps.
![How to Configure Credentials in SQL Server [HD]](http://i.ytimg.com/vi/F6vOQcWWxYo/mqdefault.jpg)
![How to Configure Credentials in SQL Server [HD]](/img/tr.png)
Hi Manzoor,
Its really helped me a lot to understand and configure the transnational replication.
Great work. thanks a lot man.
Thank you very very much, this was a neat and easy to understand Tutorial.
good video and clear instructions thenk
Need one help... Is there any way to pause replication and i can refresh subscriber full database and then resume replication
thank you very much.. this helping me so much
Very good video and clear instructions.
I got this error: "A .NET Framework error occurred during execution of user-defined routine or aggregate "sp_scriptdropdelreconciliationproc_sqlclr":
System.Data.SqlClient.SqlException: The locale identifier (LCID) 8192 is not supported by SQL Server.
"
Great, thank you very much for the detail video
Thank you so much sir.
Sir, I have a question. If an organization have multiple branches and each branch have local server. But main central database server is placed an another place e.g Headoffice. So what is a solution to update all clients data to each other on each transaction and also update main central server. and central server also have two server one is live and one is for backup. Thanks in advance.
merge replication is possible in two different city through the agent on the behalf of static ip
It's good explanation
Good Video. Two questions , how to create a network path and from where did you get the local account name for the process account. Thanks
Hi Manzoor very good presentation.
If i want to extend replication how can i do. I means. i have replication tableA last 2 month.
now i want to replication to another tableB and tableC. How can Update?
Hi Manzoor,
Prodcution standard edition 2012 (publisher) and report server 2016 web edition(subscriber) is this environment eligible for replication? (snapshot and tran repl)
Please suggest
How to use this concept?? On SQL Cluster HA configuration...
Thanks nice tutorial
Can we set the dB name to be same for the publisher DB and the subscribed DB
Thank you
Excellent
hey friend,
At last it gives me this error how to solve it...
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ No active subscriptions were found. The publication must have active subscriptions in order to post a tracer token. (Microsoft SQL Server, Error: 21488)
Excelent Work
Thank You !!
Awesome Video !! Keep it up Dude !!
How many secondary servers we can add in logshipping??
Nice video
good one
Full data is not replucate
How to slove replication issue
Hi,
I was trying to setup replication. So i went ahead and configured my distributor and then carried on with my Publisher configuration. Once i finished up with the publisher i tried starting the snapshot and log reader agents.
I get a red cross on my server in the monitoring screen and this is the eror message i get:
Login failed for user 'NT Service\SQLAgent$MSSQLSERVER3'.
I know this is something related to the DB roles as db ownership but i am unable to solve this issue.
Please help
Thanks
Najeeb - I know your post is over 6 months old but I just saw your question. Here's how I solved a similar issue like you described. Go into the properties of your database and select the "Files" selection in the left hand pane; then ensure there is an "Owner" set for the files. Mine was blank on both the Publisher and Subscriber and once I set them the issue was resolved. BTW I set the owner on both to [sa]. Hope this helps.
not bad. you should describe subscription briefly.
help me
ESILm