Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I'm trying to connect a web-part running in Sharepoint 2007 site to an external Sql Server 2005 database. I get a System.Secutity.SecurityException with "Request Failed" message when I attach debugger to debug my web part.

Here's my present situation

  1. Webpart dll is deployed in bin of web application
  2. I have set Trust Level to Full in web.config
  3. The application pool under which the sharepoint site is running is administrator on the server
  4. Here's the connection string *@"Data Source=VISHAL_vm\sqlexpress;Initial Catalog=LicensingDB;Integrated Security=True"*

This exception is thrown on Connection.Open() method

share|improve this question
add comment

1 Answer 1

I believe you need to have Kerberos configured for your SharePoint Farm and utilize SPN's on ActiveDirectory to enable that pass-through authentication.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.