How to configure MSSQL server default language configuration option?

Recently, we faced strange issue wherein one of our customers was capturing error messages coming from SQL server and writing them into database table. These error messages could not help much to customer as error messages were in Spanish language.

As a part of our primary investigation, we verified the default language of database which was set to English. Hence, we suspected the code that was writing errors to database table. However, our customer was too sure about his stored code.
Finally, after several hours of our exercise, we could resolve the problem and came to know following:

  • Customer was right on his place; his code was never in question.
  • In our primary investigation, we verified default language of database but missed the configuration of database user default language.
  • We modified the database user configuration and changed its default language to English.

Let’s see how we did it:

Configure default language option for database user from SQL Server Management Studio 2012


  1. In Object Explorer, right-click on server and select Properties.
  2. Click the Misc server settings node.
  3. In the Default language for users box, choose the language in which Microsoft SQL Server should display system messages.
  4. The default language is English.


Configure default language option for database user from Using Transact-SQL


  1. Connect to the Database Engine.
  2. From the Standard bar, click New Query.
  3. Copy and paste the following example into the query window and click Execute.
  4. The setting takes effect immediately without restarting the server.
    EXEC sp_defaultlanguage 'user_name', 'us_english' GO



  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

Fix : Server Unable to load user-specified certificate. The server will not accept a connection

You may encounter this error when you attempt to start the MSSQL service. This error occurs when...

How to identify and fix the orphan users in MSSQL Server?

Orphaned user in MSSQL means that a user who is present at the database level but the relevant...

How to install SQL Server Reporting Service (SSRS) on MSSQL 2014 Express Edition?

SQL Server Reporting Services is used for creating, publishing, and managing reports, and...

Comparison of MS SQL Server 2008 V/s. MS SQL Server 2012

Following is a feature comparison between MS SQL Server 2008 and MS SQL Server 2012. MS...

Fix :: Reporting Service Error After Upgrade From MS SQL server from 2008 to 2012

Error Message Throwing Microsoft.ReportingServices.Diagnostics.Utilities....