How to Set Connection String in SQL Server Authentication Mode in SQL

<?xml version="1.0"?>
<configuration>
  <connectionStrings>
    <add name="MyConnectionString"
         connectionString="Data Source=DESKTOP-7VHQV1F;Initial Catalog=cognate;User ID=sa;Password=12345"
         providerName="System.Data.SqlClient" />
  </connectionStrings>


  <system.web>

    <compilation debug="true" targetFramework="4.0"/>
  </system.web>
</configuration>

Leave a Reply

Your email address will not be published. Required fields are marked *