January 27, 2015 at 6:09 am
Hi Everyone
I am new to this forum and think its great! i am a junior DBA at a good company. I am having a problem replicating a database from on server to the other. I am using a transactional replication with a local distributor to a standalone single subscriber server.
My issue is that when i create a local publication,it created it fine but after when i click "View snapshot agent status" ,it runs for a while and then gives me this error:
A .NET Framework error occurred during execution of user-defined routine or aggregate "sp_scriptdropinsreconciliationproc_sqlclr":
System.Data.SqlClient.SqlException: The locale identifier (LCID) 1072 is not supported by SQL
Can anyone tell me where i am going wrong?
Thanks
February 3, 2015 at 2:21 am
Hi Everyone
So solving this issue was simple.i had the wrong windows locale language pack selected when SQL server was installed the first time .Steps i took:
1. uninstall SQL server.
2. changed locale ID to its appropriate selection (South African to USA Locale as SQL Server did not recognize my locale ID "soto" (South Africa). ).
3. re-installed SQL Server on the new locale ID.
4. Replication works.
5. Great Success.
I thought i would reply here so that anyone who has this problem know its a small yet annoying issue.I hope the steps i stated above is simple & clear enough.you can pm me if you have any trouble or if i am not clear.
Thanks 🙂
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply