Ssrs server changes nls language randomly.

Question

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

Answer 1

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