I am trying to set up replication on my SS2K5 server, however after entering the credentials for the Replication user and then hitting ok to set up the distributor I get a bunch of collation errors. I am trying to avoid changing the collation of all my databases on the server, to avoid breaking anything. Is there anyway to get past this error? I tried changing the collation on the distribution database, but I get the following warning.
Warning: Changing default collation for database 'distribution', which is used in replication. All replication databases should have the same default collation.