Re: Is Remoting The Right Tool For My Job?

James Crosswell wrote:
senfo wrote:
By the way, just so I know I covered all my grounds, impersonation in the client and application roles in SQL were also both not viable solutions for my needs. Application roles were turned down and it was determined that impersonation just would not work.

And SQL Server Authentication (instead of Windows Authentication) is also not possible? That would be easier than rebuilding everything using

You guessed it. For security reason, we cannot use SQL Server Authentication.

remoting but otherwise yeah, remoting could do the job. By default processes in IIS are run in the context of the Internet Guest Account (IUSR_MACHINENAME) though - which obviously won't have access to your SQL Server. ASP.NET installs a special user as a bit of a hack to get around this restriction - I'm not sure if/how you could configure a remoting app to take advantage of that user.

An alternative, as you say, is that you explicitly configure the website/virtualdirectory for your App in IIS to run as the user "BOB" or whatever, where BOB has access to the database that you need on the SQL Server in question... BOB probably shouldn't be an admin user or have any rights other than access to that DB on the SQL Server though.

That's what I had in mind with running the web service. Basically, IIS will host the web service running as user "BOB" and "BOB" is then granted access to the SQL Server through a role.

Thank you for the input,

--
Sean
.

Relevant Pages

  • Re: How to represent category, subcategory, product
    ... I waited days with no reply on a SQL Server ... Thanks Gene, Lennart, Neo, Bob for your suggestions, some very helpful ... Neo, your suggestion is intriguing, I'll be looking into it. ... haven't found any database counterparts of the libraries of algorithms ...
    (comp.databases.theory)
  • Re: Connextion Error After Installing SQL Server 2005 on Vista
    ... But Vista User Account Control doesn't automatically pass your administrator credentials to programs. ... The solution is to explicitly grant Bob access to SQL Server. ... During the installation, I was prompted a couple of times to install a service pack for Visual Studio 2005, which is not currently installed. ...
    (microsoft.public.sqlserver.connect)
  • Re: THANKS! -> Re: Valid MS Access SQL Syntax (Double JOINtedness)
    ... >> expanding my knowledge on the topic. ... >> Will the Access syntax work on SQL Server? ... > Bob Barrows. ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.access.formscoding)
  • Re: THANKS! -> Re: Valid MS Access SQL Syntax (Double JOINtedness)
    ... >> expanding my knowledge on the topic. ... >> Will the Access syntax work on SQL Server? ... > Bob Barrows. ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.sqlserver.programming)
  • Re: Alter Database Move column
    ... Although you didn't ask, Bob, it is often considered to be a flaw when we ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... > I have looked at the Alter Table syntax help but can't see any indication of> ordinal control. ... > alter table MasterStationTest ...
    (microsoft.public.sqlserver.server)
Loading