远程问题 [英] Remoting Problem

问题描述

我们正在开发一个分布式VB.Net应用程序，它将访问位于已知服务器上的SQL

数据库。每个客户端都将在用户的

本地计算机上运行。为了实现这一点，我们尝试使用远程处理来访问SQL服务器，并通过IIS进行远程处理。由于我们的所有

用户都将在目标域中拥有帐户，因此我们希望IIS

为我们处理安全性而不允许匿名。我们已经使用我们的开发客户端和服务器设置了这个
，但是当我们尝试连接

时，我们收到以下错误消息：

类型为''System.Net.WebException''的未处理异常发生在

mscorlib.dll


附加信息：远程服务器返回错误： （401）

未经授权。


我们的配置如下：

组件运行

Module1开发机器

开发机器上的RemotingTest IIS

另一台服务器上的NorthWind DB SQL Server


IIS配置为Windows身份验证和具有

RemotingTest对象的目录具有脚本源访问和脚本源访问。设置和执行

权限设置为脚本和可执行文件。我们还尝试使用

将IIS设置为Allow Anonymous，这会将错误移出到SQL

连接（错误消息为无法生成用户连接

NULL"）。即使匿名确实有效，但对我们来说这也是一个问题，因为我们使用的

应用程序需要访问用户名。


SQL服务器是在与开发机器不同的域中，但两个域之间存在

信任关系。我们通过在开发机器上打开企业管理器中的NorthWind数据库验证了

信任。


任何人都可以告诉我们这里我们做错了什么？

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?

推荐答案

您是否已将远程客户端设置为将默认凭据传递给

服务器？如果是这样，怎么样？此外，当您尝试浏览IE中的

服务器URL时会发生什么？

" Ron L" < RO ** @ bogus.Address.com>在消息中写道

新闻：例如************** @ TK2MSFTNGP14.phx.gbl ...

Have you set the remoting client to pass the default credentials to the
server? If so, how? Also, what happens when you attempt to browse to the
server URL in IE?
"Ron L" <ro**@bogus.Address.com> wrote in message
news:eg**************@TK2MSFTNGP14.phx.gbl...

我们正在努力分布式VB.Net应用程序，它将访问位于已知服务器上的SQL数据库。每个客户端都将在用户的本地计算机上运行。为了实现这一点，我们尝试使用远程处理来访问SQL服务器，远程处理是通过IIS进行的。由于我们所有的用户都将在目标域中拥有帐户，因此我们希望IIS能够为我们处理安全性而不允许匿名。我们已经使用我们的开发客户端和服务器设置了这个，但是当我们尝试连接时，我们收到以下错误消息：
类型''System.Net的未处理异常。 WebException''发生在
mscorlib.dll

附加信息：远程服务器返回错误：（401）
未经授权。

我们的配置是这个：
组件运行
Module1开发机器
RemotingTest开发机器上的IIS
另一台服务器上的NorthWind DB SQL Server

IIS配置为Windows身份验证和具有
RemotingTest对象的目录具有脚本源访问功能。 set和Execute
Permissions设置为Scripts and Executables。我们还试图将IIS设置为Allow Anonymous，这会将错误移出到SQL
连接（错误消息无法为用户建立连接
NULL ）。即使匿名确实有效，但对我们来说这也是一个问题，因为我们使用的应用程序需要用户名才能访问。

SQL服务器与开发机器位于不同的域中，然而，这两个域之间存在信任关系。我们已经通过在开发机器上的Enterprise
Manager中打开NorthWind数据库来验证信任是否正常工作。

谁能告诉我们这里我们做错了什么？

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?

您是否已将远程客户端设置为将默认凭据传递给

服务器？如果是这样，怎么样？此外，当您尝试浏览IE中的

服务器URL时会发生什么？

" Ron L" < RO ** @ bogus.Address.com>在消息中写道

新闻：例如************** @ TK2MSFTNGP14.phx.gbl ...

Have you set the remoting client to pass the default credentials to the
server? If so, how? Also, what happens when you attempt to browse to the
server URL in IE?
"Ron L" <ro**@bogus.Address.com> wrote in message
news:eg**************@TK2MSFTNGP14.phx.gbl...

我们正在努力分布式VB.Net应用程序，它将访问位于已知服务器上的SQL数据库。每个客户端都将在用户的本地计算机上运行。为了实现这一点，我们尝试使用远程处理来访问SQL服务器，远程处理是通过IIS进行的。由于我们所有的用户都将在目标域中拥有帐户，因此我们希望IIS能够为我们处理安全性而不允许匿名。我们已经使用我们的开发客户端和服务器设置了这个，但是当我们尝试连接时，我们收到以下错误消息：
类型''System.Net的未处理异常。 WebException''发生在
mscorlib.dll

附加信息：远程服务器返回错误：（401）
未经授权。

我们的配置是这个：
组件运行
Module1开发机器
RemotingTest开发机器上的IIS
另一台服务器上的NorthWind DB SQL Server

IIS配置为Windows身份验证和具有
RemotingTest对象的目录具有脚本源访问功能。 set和Execute
Permissions设置为Scripts and Executables。我们还试图将IIS设置为Allow Anonymous，这会将错误移出到SQL
连接（错误消息无法为用户建立连接
NULL ）。即使匿名确实有效，但对我们来说这也是一个问题，因为我们使用的应用程序需要用户名才能访问。

SQL服务器与开发机器位于不同的域中，然而，这两个域之间存在信任关系。我们已经通过在开发机器上的Enterprise
Manager中打开NorthWind数据库来验证信任是否正常工作。

谁能告诉我们这里我们做错了什么？

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?

问题是IIS连接在登录前是匿名的。使用本地应用程序，你

没有登录框，所以你留下来。繁荣!!!


良好的起点：
http://msdn.microsoft.com/library/en...SecNetch11.asp


我假设您正在使用HTTP作为传输（IIS），因为您需要内置的

身份验证方法。这很好，但意识到你必须有

用户登录，或者让机器设置为自动使用用户的

帐户。网络管理员可以通过政策将其推出，以避免单独设置机器。


-

Gregory A. Beamer

MVP; MCP：+ I，SE，SD，DBA


***************************

在盒子外面思考！

*************************** >
Ron L写道：

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

我们正在开发一个分布式VB.Net应用程序，它将访问位于已知服务器上的SQL数据库。每个客户端都将在用户的本地计算机上运行。为了实现这一点，我们尝试使用远程处理来访问SQL服务器，远程处理是通过IIS进行的。由于我们所有的
用户都将在目标域中拥有帐户，因此我们希望IIS为我们处理安全性而不允许匿名。我们已经与我们的一个开发客户端和服务器进行了设置，但是当我们尝试连接时，我们收到以下错误消息：
类型为''System.Net的未处理异常。 WebException''发生在
mscorlib.dll

附加信息：远程服务器返回错误：（401）
未经授权。

我们的配置是这个：
组件运行
Module1开发机器
RemotingTest开发机器上的IIS
另一台服务器上的NorthWind DB SQL Server

IIS配置为Windows身份验证和具有
RemotingTest对象的目录具有脚本源访问功能。 set和Execute
Permissions设置为Scripts and Executables。我们还试图将IIS设置为Allow Anonymous，这会将错误移出到SQL
连接（错误消息无法为用户建立连接
NULL ）。即使匿名确实有效，但对我们来说这也是一个问题，因为我们使用的
应用程序需要用户名才能访问。

SQL服务器与开发机器位于不同的域中，但是这两个域之间存在信任关系。我们通过在开发机器上的企业管理器中打开NorthWind数据库来验证信任是否正常工作。

任何人都可以告诉我们我们在这里做错了什么？

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?

这篇关于远程问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！