Share via

Change collation of report services

Posmine Poulose k 0 Reputation points
2025-02-28T10:56:40.1+00:00

I noticed that the default collation for the Report Server databases (ReportServer and ReportServerTempDB) in SQL Server Reporting Services is Latin1_General_100_CI_AS_KS_WS. However, my SQL Server instance collation is SQL_Latin1_General_CP1_CI_AS.

I want to change the Report Server database collation to match the SQL Server instance collation (SQL_Latin1_General_CP1_CI_AS), but all the methods I’ve tried so far have failed.

  1. Why does Reporting Services use a different collation for its databases?
  2. What is the correct method to change the collation of these databases to match the SQL Server instance? If anyone has successfully achieved this or has guidance (official documentation or steps), please share.
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,008 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 46,201 Reputation points
    2025-02-28T11:05:04.38+00:00

    I want to change the Report Server database collation to match the SQL Server instance collation

    Why? I can't image that the collation of the RS database matters here; I have no issues with.

    It's not supported to modify the RS databases in any way.

  2. Erland Sommarskog 119K Reputation points MVP
    2025-02-28T22:29:10.1833333+00:00

    I agree with Olaf, why would you change the collation? And if you are to change the collation, I would recommend that you change the server collation instead, since that is an older and less versatile collation.

    But if you would need to change the collation of a database, I happen to have an article about it on my web site: https://www.sommarskog.se/collation-change.html It comes with scripts and tips to help you with this very complex operation. (It is easier to change only the server collation.)

  3. ZoeHui-MSFT 41,286 Reputation points
    2025-03-03T06:05:10.4933333+00:00

    Hi @Posmine Poulose k，

    The RS DB's are created by script which is done at the configuration stage.

    As these DB's are only ever used by the SSRS service then there is no logical need to change the collation.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments
  4. Olaf Helper 46,201 Reputation points
    2025-03-03T07:45:50.96+00:00

    BTW, only 2 views returns datatype "varchar", so the database collation do not really matter.

    SELECT * 
FROM [ReportServer].[INFORMATION_SCHEMA].[COLUMNS]
WHERE DATA_TYPE IN (N'char', N'varchar')
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.