Ssrs server changes nls language randomly.

Vincent Jonkers 0 Reputation points
2023-10-25T08:56:17.5933333+00:00

Hi,

I have a very stramge issue every now and then the server decides to change the languade settings for my oracle datasource. Nothing happens on the oracle database. The issue happens and my datasource that notmally works fine swaps to Czech or Brasil or French. The report than errors on specific date or day sql statements and we can fix this by shutting down services and restarting the service. Or changing the connect sting to direct connection not tns_names.

issue always happens after a recycle of the server cache. Setting from the reportserver.config.

Anybody have any idea.

opd.net does not allow you to default the language so i have no idea where to set a static language for the report server.

Kind Regards,

Vincent

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,525 questions
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.
2,849 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,486 questions
Microsoft Configuration Manager
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,341 Reputation points Microsoft Vendor
    2023-10-26T01:40:31.1666667+00:00

    Hi @Vincent Jonkers

    According to official documentation:

    The Language property on a paginated report or a text box contains the locale setting, which determines the default formats for displaying report data that differ by language and region. If no value is specified for Language, Reporting Services uses the locale of the operating system on the report server for published reports or of the report authoring computer for report preview.

    For more information on reporting locales, you can check out this documentation: Set the locale for a paginated report or text box.

    You can also try changing your browser's language settings or your computer's regional settings.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    0 comments No comments