Web site with MS SQL server database show Internal Server Error 500.19

Created:

2016-11-16 13:10:38 UTC

Modified:

2017-04-24 11:22:06 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Web site with MS SQL server database show Internal Server Error 500.19

Applicable to:

  • Plesk for Windows

Symptoms

Website with database on MSSQL server shows 500.19 Internal Server Error , error code 0x8007000d.

HTTP Error 500.19 - Internal Server Error

Error Code
0x8007000d

Config Error
Configuration file is not well-formed XML

Config File
\\\\?\\C:\\Inetpub\\vhosts\\domain.tld\\httpdocs\\web.config

Config Error
Configuration file is not well-formed XML

Config Source:
13: <add name="SQL DB" connectionString="Data Source=.\\MSSQLSERVER2014;Initial Catalog=db-name;Integrated Security=False;User Id=UserName;Password=MyPass&word;" providerName="System.Data.SqlClient" />

Cause

Special characters in connection string were not escaped.

Resolution

Since the web.config is XML, the following special characters have to be escaped:

&amp;  ->  & ampersand, U+0026
&lt; -> < left angle bracket, less-than sign, U+003C
&gt; -> > right angle bracket, greater-than sign, U+003E
&quot; -> " quotation mark, U+0022
&apos; -> ' apostrophe, U+0027

Edit web.config file and replace all special characters according to the table above. Example, MyPass&word = MyPass&amp;word

Have more questions? Submit a request
Please sign in to leave a comment.