Problem
The following error occurs when running date based reports on workstations with a default language settings other than US (English)
Error Number : 1005
Description : Can't open recordset (check RecordSource string).
This error can occur if the SQL Server is not set to use the same language as the workstation. Normally the SQL Server will pick up on the default language during the installation.
Solution
You can manually set the default SQL Server language with the Server Console using the steps below. If you have Server Console version 3.1.1 or higher you can enter the commands using the Advanced->Run SQL Command feature, otherwise you will need to save the commands to a script file (fix.sql) and use the Advanced->Run SQL Script to select the script file.
First you will need to determine the language to use by running the commands below. You will need to use the langid for the desired language.
use master
select * from syslanguages
Next you can set the default language using the command below. Replace 0 with the langid for the desired language.
use master
exec sp_configure 'default_language' , 0
reconfigure
exec sp_configure
