Re: Is Remoting The Right Tool For My Job?

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 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.

Best Regards,

James Crosswell
Microforge.net LLC
http://www.microforge.net
.

Relevant Pages

  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)
  • Re: WSUS
    ... I'm not seeing performance issues with the full enchilada installed, and 25 users busy hitting SQL. ... WSUS isn't difficult to uninstall - if you have WSUS v2 (installed with SBS R2) uninstall R2 from add/remove programs. ... How can anyone work with 4 instances of SQL Server on the same box? ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Resets
    ... If it were SQL that was falling short, ... The default backlog for SQL Server is 5. ... System.InvalidOperationException: Internal connection fatal error. ... From time to time, under heavy loads, we are getting resets at ...
    (microsoft.public.sqlserver.connect)
Loading