Re: Best Means: Calling a Function or Application on a Remote Server



On Mar 11, 12:18 pm, Pavel Minaev <int...@xxxxxxxxx> wrote:
On Mar 11, 9:25 am, "jehugalea...@xxxxxxxxx" <jehugalea...@xxxxxxxxx>
wrote:

Hello:

Our users have an application where they can initiate jobs on our
servers. Currently, we have Oracle stored procedures that execute
applications on the database server. We hate using the database this
way.

We would like our applications to be run without needing to initiate
them with a database.

We are currently gathering information on the approaches we can take.
What are some options?

If I understand you correctly, you essentially want to do RPC between
two machines. In that case...

The default one would be a Web service (easiest to write, popular
approach so lots of examples/tutorials, good integrated
security). .NET remoting is another option. Then of course there's COM
+ components and MSMQ.

What would be the most scalable option?

Depends on your scenario, and on how you implement the server side.
All of them are potentially scalable.

How do we authenticate users?

If you're using .NET in a Windows-only environment with a domain, then
integrated Windows authentication seems to be the most logical
solution. Both ASP.NET web services and WCF support it out of the box,
you just need to configure them to do it.

What other security measures do we need to take?

Hard to say without knowing what you do, but you might want to protect
the data that is transmitted from clients to the server. If you use
Web services for that, then you'd just use SSL/TLS.

What needs to be on the machine in order for the code to run?

For any .NET solution - .NET, obviously. Anything else is optional;
with WCF, you can have a self-hosting Web service application, for
example, and .NET remoting has always allowed to embed hosts into .exe

In practice, most people host their Web services in IIS.

Most of our applications need the database SID, user name and password
passed in. How can pass this information securely? (We can always use
Oracle proxy authentication.)

If you use Windows integrated authentication and WCF, you needn't
worry - it will handle it all in a secure way.

Well, you named some technologies. That is what I am looking for. I
suggested Web services myself; we would probably just go the IIS
route. I am not sure if our sys admins would appreciate that. :-P

I will look into .NET remoting, too. I want to weight all our options
before I push for anything.

Thanks!
.



Relevant Pages

  • Re: Best Means: Calling a Function or Application on a Remote Server
    ... applications on the database server. ... We would like our applications to be run without needing to initiate ... and on how you implement the server side. ... Web services for that, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Communications between different .NET Applications
    ... large chunk of data around use .net remoting. ... bit harder to setup and get running than web services but it better ... Web services you will essentially have the clients talking to the server ... > My desire is to have client versions of my application running on a couple ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Alternative to Remoting?
    ... > server and retreive them later. ... > I thought about using web services, but they doesn't mantain the table to ... You could create a new reader, ... > In Windows Applications the solution is using .NET Remoting but I found ...
    (microsoft.public.dotnet.framework.compactframework)
  • Remoting Design Question
    ... To provide a high level of scalability, the web services interface ... windows service that accepts requests via TCP on a specified port. ... Obviously, those requests are then sent to the database, and results are ... possible when I'm working with .Net remoting. ...
    (microsoft.public.dotnet.framework.remoting)
  • .NET WEB Service, MS SQL Server and Integrated Security
    ... uses .NET WEB services to synchronize data between the ... client application and MS SQL Server. ... I am trying to use integrated security in the connection ... string for the database from WEB service. ...
    (microsoft.public.dotnet.security)

Loading