Friday 5 December 2014

SharePoint WebPart SQL Connection string

<add name="AdventureWorksConnectionString"
connectionString="Data Source=SQLServerName;Initial Catalog=DbName;Persist Security Info=True;User ID=sa;Password=Microsoft"
        providerName="System.Data.SqlClient" />

<add name="AdventureWorksConnectionString" connectionString="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DBName;Data Source=SQLServerName"
        providerName="System.Data.SqlClient" />