Replication Collation error...

[coder_t2]

I am working on setting up replication on SQL Server 2005, and I was hoping to get some help with it. I am finally at the point where I have a replication userid with all the correct permissions. But I get a collation error when trying to set up the distribution. I tried changing the collation of the distribution database but I get the following error.

Warning: Changing default collation for database 'distribution', which is used in replication. All replication databases should have the same default collation.

I was hoping to avoid changing the collation of all databases for fear of it causing problems with reports that are already running. Any Ideas?

Here are some pics that might help show where I am stuck.
At this point I click OK.
http://img24.imageshack.us/img24/294/distributor.jpg
Then I get error!
http://img686.imageshack.us/img686/1000/disterror.jpg

 

[KLin]

Interesting, I never had any issues with the collation while configuring distribution on SQL Server.

 

[coder_t2]

This server switched physical machines a few months ago, so I wonder if originally the databases were set up with one collation, and sql server was set up with a different collation when it was set up on the new box. I try getting to properties of the database to double check the collation and I get a collation error...

I can confirm that the original sql server settings were SQL_Latin1_CP1_CI_AS. Trying to figure out the current sql server settings are....

Also I am trying to replicate from an Oracle database, if that helps.

 

[KLin]

You can do a select against sys.databases to get the current collation setting for each database in the master database.

 

[coder_t2]

Ok, tempdb, model and msdb are Latin1_General_Bin and the rest are SQL_Latin1_CP1_CI_AS.