Community
Showing results for 
Search instead for 
Do you mean 
Reply

set up remote synchronization failure

Accepted Solution Solved
Copper Contributor
Posts: 22
Country: Hong_Kong
Accepted Solution

set up remote synchronization failure

I'm trying to setup remote synchronization for a mobile user, and I get the following error:

 

"Failed to create remote database 'testing'.  Cannot resolve teh collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.  Please contact the administrator for more help"

 

I'm using SQL Server Express 2008 on SQL Server 2003 32 bit.  The database "test2" was created using act.  

 

The server collation is set to: SQL_Latin1_General_CP1_CI_AS

 

The database collation of "test2" is set to Latin1_General_CI_AS

 

Does anyone have any idea

 

  1. why Act / SQL Express are mixing up the collation?
  2. how to fix the collation of a database after it has been created?
  3. how to stop Act / SQL Express from messing this up the next time I create a database.

Any advice would be greatly appreciated.


Accepted Solutions
Solution
Accepted by topic author pdwalker
‎09-25-2015 03:20 AM
Copper Contributor
Posts: 22
Country: Hong_Kong

Re: set up remote synchronization failure

solved it by reinstalling the SQL Express database according to these instructions:

http://kb.swiftpage.com/app/answers/detail/a_id/26994/kw/change%20sql%20server

 

The important part is making sure the code page and sort options were set correctly.

View solution in original post


All Replies
Copper Contributor
Posts: 22
Country: Hong_Kong

Re: set up remote synchronization failure

or more simply, how do I get the remote synchronization to work given my current circumstances
Solution
Accepted by topic author pdwalker
‎09-25-2015 03:20 AM
Copper Contributor
Posts: 22
Country: Hong_Kong

Re: set up remote synchronization failure

solved it by reinstalling the SQL Express database according to these instructions:

http://kb.swiftpage.com/app/answers/detail/a_id/26994/kw/change%20sql%20server

 

The important part is making sure the code page and sort options were set correctly.