I have created some custom WebParts on my SharePoint site through the use of SmartParts. My custom web parts look at 2 diff. SQL Server Datasources.
- When i run my code from Visual Studio 2008 is works 100%
- When i deploy my code on the SharePoint Page it works 100% when i run it from the server
But when i access the SharePoint site from my local PC and i hit that custom Webpart i get the error that say "403 FORBIDDEN". Now i know its a security problem but where and why? And why does it work on the SERVER and not from another PC??
Any help would be great!!
Edit:
MY ConnectionString in my Web.config
<add name="DSN" connectionString="Data Source=TCP:us-support.a1.mydomain.com;
Initial Catalog=myDB;Integrated Security=false;User ID=myID;Password=myPassword"
providerName="System.Data.SqlClient" />