title: Change language in SQL Server connection string
body: <p>I have a SQL Server in Azure, with default language eu_english. That means that the dates are in format mdy and I need them in dmy, I want to put the language to Spanish in the connection string. I have tried this. but it doesn't work:</p>
  <pre><code>jdbc:sqlserver://myazureURL:1433;DatabaseName=MyDataBase;Language=Spanish
  </code></pre>
  <p>I have tried adding Language=Spanish, but it doesn't work. I have also tried Language=5 because 5 is the Spanish Id of languages of my SQL Server.</p>
  <p>I need this because I can't change default language from database settings. If I try to change default language with that:</p>
  <pre><code>EXEC sp_configure 'default language', 'Spanish';
  </code></pre>
  <p>It gives me this error:</p>
  <pre><code>EXEC sp_configure 'default language', 'Spanish';
  </code></pre>
  <p>EDIT WITH SOLUTION:
  I solved it incluiding this to the connection String so in each connection it sets the language:</p>
  <pre><code> connectionInitSqls =&quot;SET LANGUAGE Spanish&quot;
  </code></pre>