Hi,

We are connecting webpart to a external SQL Server Database through a Windows Authentication. We are unable to connect this from a SharePoint and get an error, "Login failed for user 'NTAUTHORITY\ANONYMOUS LOGON".

But while we connect from a Windows Form Application, We are able to connect to the Database

Any Ideas of how to establish connection between webpart and external sql server database.

Hi Sam,

From your description, my understanding is that you get error when you connect to external sql server database.

Please try to use SPSecurity.RunWithElevatedPrivileges(delegate()) method in your code, here is a similar case for your reference:

https://social.msdn.microsoft.com/Forums/office/en-US/abb17c3d-0821-415b-bc96-b5559c52cf5a/call-sql-connection-in-visual-webpart?forum=sharepointdevelopment

Best Regards,

Vincent Han

We are trying to connect to External Database through Sharepoint via Windows Authentication "DOMAIN\NetworkID". This is because, we need to start a job in SQL Server using Windows Authentication.

But we are unable to establish the connection using "DOMAIN\NetworkID", but we will be able to connect using SQL Authentication. We do tried with a sample .NET Application for connectivity which worked.

Use External Content Type. So that you can use BCS service to display SQL data in your web part

Thanks Sundar, Will try this...

Just want to confirm whether we can execute a Stored Procedure in the External SQL Server using the External Content Type?

Hi Sam,