June 15, 2007 at 6:39 am
I am trying to create a new user in a Database on our Test Server. As soon as I right click "New Database user" I get Error 446: cannot resolve collation conflict for equal to operation.
Research shows that Databases on the server have a mixture of 2 different Collations, the error appears on all Databases. Master and MSDB have the same Collation but temp has a different collation. Unable to change collation of temp as it is a system Dbase, although not sure that this would solve the problem anyway.
Any ideas out there? Have run out of them here!
Thanks
Colin
June 15, 2007 at 7:44 am
This looks weird. Try adding the user using TSQL and see what it says.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 15, 2007 at 8:19 am
I have managed to force it through, but am not happy about the situation. Could be that we need to rebuild the test server. Now there is a nice job for next week! 😉
Thanks for the suggestion.
Colin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply