Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Connect SQL Server to ASP.NET 3.5 with Windows Authentication Expand / Collapse
Posted Wednesday, July 16, 2008 1:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 8, 2016 6:35 PM
Points: 207, Visits: 612
Hi every bodies, I have already read this Web site :
but still failed to use Windows Auth.

The original connectionString in the Web.Config file :
<add connectionString="Data Source=;
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=;
Initial Catalog=backoffice2;Integrated Security=SSPI";

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 ?

  Post Attachments 
Server Error in.doc (24 views, 24.00 KB)
Post #534928
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse