RE: Remoting Problem

From: Cowboy (Gregory A. Beamer) - MVP (NoSpamMgbworld_at_comcast.netNoSpamM)
Date: 05/31/05


Date: Tue, 31 May 2005 09:10:03 -0700

The issue is IIS connections are anonymous until login. With a local app, you
do not get a logon box, so you stay anon. Boom!!!

Good starting point:
http://msdn.microsoft.com/library/en-us/dnnetsec/html/SecNetch11.asp

I assume you are using HTTP as transport (IIS) as you want the built in
authentication methods. That is fine, but realize you will have to have the
user log in, or have the machines set up to automatically use the user's
account. Network admins can push this out, via policy, to avoid individually
setting up machines.

-- 
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"Ron L" wrote:
> We are working on a distributed VB.Net application which will access a SQL 
> database located on a known server.  Each client will run on the user's 
> local machine.  To implement this, we are trying to use remoting for our 
> access to the SQL server, with the remoting being via IIS.  Since all of our 
> users will have accounts in the destination domain, we want to have IIS 
> handle the security for us and not allow anonymous.  We have set this up 
> with one of our development clients and servers, but when we try to connect 
> we get the following error message:
>       An unhandled exception of type 'System.Net.WebException' occurred in 
> mscorlib.dll
> 
>       Additional information: the remote server returned an error: (401) 
> Unauthorized.
> 
> 
> 
> Our configuration is this:
>       Component         Running on
>       Module1               the development machine
>       RemotingTest        IIS on the development machine
>       NorthWind DB     SQL Server on another server
> 
> IIS is configured for Windows Authentication, and the directory with the 
> RemotingTest object has "Script Source Access" set and the Execute 
> Permissions are set to "Scripts and Executables".  We have also tried with 
> setting IIS to Allow Anonymous, which moves the error out to the SQL 
> connection (with the error message of "can't make a connection for user 
> NULL").  Even if anonymous did work, it would be a problem for us since the 
> application we are using requires the username to be accessible.
> 
> The SQL server is in a different domain from development machine, however a 
> trust relationship exists between the two domains.  We have verified that 
> the trust works by opening the NorthWind database in Enterprise Manager on 
> the development machine.
> 
> Can anyone tell us what we are doing wrong here?
> 
> 
> 
> 


Relevant Pages

  • Re: RPC-HTTP problems
    ... Exchange access within our office and with OWA access outside our ... rpc-http connection to work outside our office. ... assure iis is allowing the rpcproxy.dll web extension. ... server is unavailable" ...
    (microsoft.public.windows.server.sbs)
  • Re: accessing data mining model via web/PDA
    ... Is your OPENROWSET clause connecting to a SQL Server 2000 database? ... Is your SQL Server instance running on the same machine as your Analysis ... i need some> help for the connection string, let say to access the> mining model in the AS. ...
    (microsoft.public.sqlserver.datamining)
  • Re: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Collection of email
    ... Yes Peter you are right IIS is a product I have never used before therfore I ... The server runs a permenant online connection through a ISDN channel 64K. ... Just as a subnote VPOP3 is installed on the server with the Internet and IIS ...
    (microsoft.public.inetserver.iis.smtp_nntp)
  • Re: VB Express SQL Express Remote Connection
    ... Yes I can connect using the SQL Server Management Studio Express Tool. ... I changed my connection to exactly what you specified and it connected. ... I can connect and create databases on the Remote Server ...
    (microsoft.public.dotnet.languages.vb)