how to create a web part that access sql server different from sharepoint server

Question

How to create a web part on sharepoint server A that access a database on sql server B

I am new to sharepoint.

Thanks

---

sz

Answer 1

Hi Semika,

Accessing a different database from your SharePoint WebPart works just like it would from a 'normal' .NET application. You can write your connection in your C# code behind file. Have a look at the link below which explains a basic guide:

http://www.codeproject.com/Articles/4416/Beginners-guide-to-accessing-SQL-Server-through-C

Cheers,
Vincent

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Thank you.

---

sz

Answer 3

as my practice says, it wont let access SQL that is on different server.. there is double hop problem, and SQL see incomming traffic as anonymous.. with SQL auth it works, with window auth - wont