impersonation

Hi,

I need to connect to a remote SQL server from a webservice. The webservice
(IIS) and SQL server are running on different machines. I'd like to use
windows authentication rather than SQL one.
How can I achieve this? through impersonation? what are the implications of
using impersonation? is there a better way?

Thanks, Ohad

--
Ohad Young
Medical Informatics Research Center
Ben Gurion University
Information System Eng
Office Phone: 972-8-6477160
Cellular Phone: 972-54-518301
E-Mail: ohadyn@xxxxxxxxxxxxxxxxx


.

Relevant Pages

  • Re: ThreadAbort Exceptions !! HELP !!
    ... Well we checked for queued requests last night and there were none during ... Looks like our SQL server box is ... trace seems to usually point at a webservice not an aspx page. ... System.Threading.WaitHandle.WaitOne(Int32 millisecondsTimeout, Boolean ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Scalability questions....
    ... Hardware code is faster than software code (i.e. hardware SSL is faster than software SSL). ... We averaged 60 MB/sec of bandwidth and used SQL Server to log and analyze the downloads. ... But how do I write a data intensive webservice that can be ...
    (microsoft.public.dotnet.general)
  • RE: Webservice can not connect to Sql server 2000
    ... Windows service pack. ... All i am dong is trying to open a connection from a .Net webservice (using ... IIS installed on it and connecting to the sql server which is running on ...
    (microsoft.public.sqlserver.connect)
  • Proxy Authentication error when calling a webservice from SQL2K stored proc
    ... I'm performing a webservice call from a SQL Server stored proc. ... Authentication Required.' ...
    (microsoft.public.sqlserver.programming)
  • Debugging HTTP 500 errors
    ... frequently the IIS log shows a status 500 being returned to the ... Webservice protected using basic authentication. ... SQL Server 2000 with the latest service pack and updates. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)