Connect SQL Server to ASP.NET 3.5 with Windows Authentication

• onlo

  SSCertifiable

  Points: 5080

  More actions

  July 16, 2008 at 1:12 am

  #126459

  Hi every bodies, I have already read this Web site :

  http://msdn.microsoft.com/en-us/library/ms998292.aspx

  but still failed to use Windows Auth.

  The original connectionString in the Web.Config file :

  <add connectionString="Data Source=192.168.1.141;

  Initial Catalog=backoffice2;User ID=openrice;Password=openrice" name="BackOffice" providerName="System.Data.SqlClient"/>

  I changed it like this :

  <add name="MyDbConn1" connectionString="Data Source=192.168.1.141;

  Initial Catalog=backoffice2;Integrated Security=SSPI";

  providerName="System.Data.SqlClient"/>

  Please see the attached Word file for error details.

  Once I changed back to use the original connectionString, every things resumed normal.

  What is the proper procedure ? Did I miss any steps ?