2012 sql reporting collation

Category: sql server documentation


Haggisness on Fri, 15 Feb 2013 14:00:53

hey all,

I just installed my new 2012 sql box with native reporting services. the server and analysis coalltion is set to SQL_Latin1_General_CP1_CI_AS but I had no option to change the reporting collation and it seems default of Latin1_General_CI_AS_KS_WS was used. How can this be changed and where? The server is clean with no data other than system dbs and due to SCOM 2012 I need this changed before proceeding.

please help....


Allen Li - MSFT on Mon, 18 Feb 2013 02:03:39

Hi Haggisness,

As far as I know, this is by design and we don’t need to worry about it. There are some similar questions on the following links, you can refer to them: