The configuration section cannot contain a CDATA or text element

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: The configuration section cannot contain a CDATA or text element.

Source Error:

Line 12: <!--<add name="DefaultConnection" connectionString="data source=sql6009.site4now.net;Initial Catalog=SMS_BizSagar;user id=DB_A3DD8E_sms_admin;[email protected]" providerName="System.Data.SqlClient" />

Line 13: <add name="SMSEntities" connectionString="metadata=res://*/SMS.Entities.SMS.csdl|res://*/SMS.Entities.SMS.ssdl|res://*/SMS.Entities.SMS.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=sql6009.site4now.net;initial catalog=DB_A3DD8E_sms;user id=DB_A3DD8E_sms_admin;[email protected];MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />-->

Line 14: <add name="DefaultConnection" connectionString="data source=45.115.218.242,1433;Initial Catalog=BasicSMS;user id=sa;[email protected]#$" providerName="System.Data.SqlClient" />s

Line 15: <add name="SMSEntities" connectionString="metadata=res://*/SMS.Entities.SMS.csdl|res://*/SMS.Entities.SMS.ssdl|res://*/SMS.Entities.SMS.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=45.115.218.242,1433;initial catalog=BasicSMS;user id=sa;[email protected]#$;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

Line 16: </connectionStrings>

Answer

Option 1.

Line 14: <add name="DefaultConnection" connectionString="data source=45.115.218.242,1433;Initial Catalog=BasicSMS;user id=sa;[email protected]#$" providerName="System.Data.SqlClient" />s

providerName="System.Data.SqlClient" />s Remove "s" from your code

There are some another cases 

Option 2.

Usually this error comes when there is invalid syntax in web config file

Option 3.

You have a stray / next to one of your comments.

Option 4.

Make sure there's no stray character in the configuration file. It can be as "harmless" as a misplaced "-->" or extra ." or anything really minor.

Option 5.

Data Source=YourSQLServerName;Database=DatabaseName; uid=ServerUserID; pwd=YourServerPassword;",