Error -2147217900: Cannot resolve collation conflict for equal to operation

(0) Share

Report

Posted on by Umar Khitab

750

Helo , thanks in advance to help me

In Microsoft RMS when i try to connect the Microsoft Headquarter Client to Headquarter Server the follwing error is come (Error -2147217900: Cannot resolve collation conflict for equal to operation) . please help me to solve this problem

I think this problem is occured because in Store Operation Administrator the server Collation and Databas collation is not same. can any body guide me how can i change server collation in Store Operation Administrator.

Please Reply me as early as possible.

Thanks

Umar Khitab

*This post is locked for comments

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Error -2147217900: Cannot resolve collation conflict for equal to operation

You can change database collation easy from Store operations administrator, connect, enter sa password, database, chenage collatio.

but changeing server collation would be hard, its better reinstall the SQL with advanced options.

make all HQ Stores (servers and databases the same)

Thank you
Mohammed El Qadi
http://www.fact.fm/viewforum.php?f=30