Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Wednesday, July 16, 2008 1:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:43 AM
Points: 193, Visits: 547
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 ?


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

Add to briefcase

Permissions Expand / Collapse