design question about webservices

Hi,

I need to expose data in a SQL server 2005 database as a webservices. I have 2 options to choose. I can create an End point in sql or build a webservices in .NET.

So what are de advantages and disadvantages of those 2 approaches ?

Of course they want the webservices secure. I know that authentication is not a problem since we use windows integrated security for the intranet. But what will happen if we move to an extranet or the internet ?

But how do you enable authorization ? and Context security ? Is context security better done in .NET then in SQL ?

Thanks in advance.

Deciding which approach is better for your scenario will also depend on a couple key questions:

If the expected workload requires you to have some web farm like scalability, then you will need to go with ASP.NET If you need the ability to customize the WSDL generation and/or web method result structure then you need to go with ASP.NET|||

It is very clear.

Thank you very much.

CE