It appears that the collation for my SQL server: SQL_Latin1_General_CP1_CI_AS differs from what my report server has set: Latin1_General_CI_AS_KS_WS
I'm a bit confused by this as I guess I assumed that what I selected for SQL server during the installation would be used by all the databases on the system when they were created (including the report server database).
So as I understand it I need to change the collation of my report server, and to do that I basically have to create a new reprot server database on the SQL server.
However, how can I ensure that the new database will use the proper collation? (How can I check what my DEFAULT collation is set for on the server?)