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
- Webpart dll is deployed in bin of web application
- I have set Trust Level to Full in web.config
- The application pool under which the sharepoint site is running is administrator on the server
- Here's the connection string *@"Data Source=VISHAL_vm\sqlexpress;Initial Catalog=LicensingDB;Integrated Security=True"*
This exception is thrown on Connection.Open() method