集成认证。 [英] Integrated Authentication.

问题描述

在我的web.config文件中，我已指定Windows进行身份验证，在IIS中

我已将其设置为集成身份验证。


但是我的SQL连接仍然显示Anonymous。

我还需要检查其他地方吗？


谢谢

赢取2003 ，SQL Server 2000

解决方案

Tom，


当你说你的SQL连接是什么意思仍然显示

anonymous？


Jim Cheshire [MSFT]

开发人员支持

ASP。 NET
ja******@online.microsoft.com


此帖子按原样提供，不提供任何保证，也不授予任何权利。


----------------- ---

From：" Tom B" < sh ***** @ NOSPAMhotmail.com>
主题：综合身份验证。
日期：2003年10月16日星期四11:19:41 -0400
行数：12 X-Priority：3
X-MSMail-Priority：正常
X-Newsreader：Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE：由Microsoft MimeOLE制作V6.00.2800.1165 新闻组：microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host：216.46.141.98
路径：cpmsftngxa06.phx.gbl！TK2MSFTNGP08.phx.gbl！TK2MSFTN GP11.phx.gbl
外部参照：cpmsftngxa06.phx.gbl microsoft.public.dotnet。 framework.aspnet：184652
X-Tomcat-NG：microsoft.public.dotnet.framework.aspnet
在我的web.config文件中，我已经在IIS中指定了Windows进行身份验证
我已将其设置为集成身份验证。

但我的SQL连接仍然显示Anonymous。
我还需要检查其他地方吗？

谢谢

Win 2003，SQL Server 2000

好吧，我抓住错误并写出消息，这是.....


登录用户''NT AUTHORITY \ANONYMOUS登录'失败。


和Profiler显示相同。

" Jim Cheshire [MSFT] " < JA ****** @ online.microsoft.com>在消息中写道

新闻：m2 ************** @ cpmsftngxa06.phx.gbl ...

Tom，
当你说你的SQL连接仍然显示匿名时你是什么意思？

Jim Cheshire [MSFT]
开发人员支持
ASP。 NET
ja******@online.microsoft.com

这篇文章是按原样提供的，没有任何保证，也没有赋予任何权利。

--------------------

From：" Tom B" < sh ***** @ NOSPAMhotmail.com>
主题：综合身份验证。
日期：2003年10月16日星期四11:19:41 -0400
行数：12 X-Priority：3
X-MSMail-Priority：正常
X-Newsreader：Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE：由Microsoft MimeOLE制作V6.00.2800.1165 新闻组：microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host：216.46.141.98
路径：cpmsftngxa06.phx.gbl！TK2MSFTNGP08.phx.gbl！TK2MSFTN GP11.phx.gbl
外部参照：cpmsftngxa06.phx.gbl
microsoft。 public.dotnet.framework.aspnet：184652X-Tomcat-NG：microsoft.public.dotnet.framework.aspnet
在我的web.config文件中，我已经指定了Windows进行身份验证，
IISI已将其设置为集成身份验证。

但我的SQL连接仍然显示Anonymous。
我还需要检查其他地方吗？

谢谢

Win 2003，SQL Server 2000

Tom，


您使用的是SQL Server身份验证还是Windows身份验证

SQL Server？听起来像是在使用Windows，在这种情况下，你需要给ASP.NET进程帐户访问SQL Server

数据库，或者你需要模仿。


Jim Cheshire [MSFT]

开发人员支持

ASP.NET
ja ****** @ online.microsoft.com


这篇文章提供为 - 没有保证，也没有赋予任何权利。

--------------------

来自："汤姆B" < sh ***** @ NOSPAMhotmail.com>
参考文献：< #F ************** @ TK2MSFTNGP11.phx.gbl>
< m2 ************** @ cpmsftngxa06.phx.gbl>主题：回复：综合认证。
日期：2003年10月16日星期四16:00： 47 -0400
行数：55
X-Priority：3
X-MSMail-Priority：正常
X-Newsreader：Microsoft Outlook Express 6.00.2800.1158
X- MimeOLE：由Microsoft MimeOLE制作V6.00.2800.1165
消息ID：< ut ************** @ TK2MSFTNGP10.phx.gbl>
新闻组：microsoft .public.dotnet.framework.aspnet
NNTP-Posting-Host：216.46.141.98
路径：cpmsftngxa06.phx.gbl！TK2MSFTNGP08.phx.gbl！TK2MSFTN GP10.phx.gbl
外部参照：cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet：184756
X-Tomcat-NG：microsoft.public.dotnet.framework.aspnet

好吧，我抓到了错误并写出消息，这是.....

登录失败的用户''NT AUTHORITY \ANONYMOUS登录''。

和Profiler显示相同。

" Jim Cheshire [MSFT]" < JA ****** @ online.microsoft.com>在消息中写道
新闻：m2 ************** @ cpmsftngxa06.phx.gbl ...

Tom，
当你说你的SQL连接仍然显示匿名时你是什么意思？

Jim Cheshire [MSFT]
开发人员支持
ASP.NET
ja******@online.microsoft.com

这篇文章按原样提供，不提供任何保证，也不授予任何权利。

--------------------

> ;来自：汤姆B < sh ***** @ NOSPAMhotmail.com>
>主题：综合身份验证。
>日期：星期四，2003年10月16日11:19:41 -0400
>行数：12
> X-Priority：3
> X-MSMail-Priority：正常
> X-Newsreader：Microsoft Outlook Express 6.00.2800.1158
> X -MimeOLE：由Microsoft MimeOLE制作V6.00.2800.1165
>消息ID：< #F ************** @ TK2MSFTNGP11.phx.gbl>
>新闻组：microsoft.public.dotnet.framework.aspnet
> NNTP-Posting-Host：216.46.141.98
>路径：cpmsftngxa06.phx.gbl！TK2MSFTNGP08.phx.gbl！TK2MSFTN GP11.phx.gbl
> Xref：cpmsftngxa06.phx.gblmicrosoft.public.dotnet.framework.aspnet：184652> X-Tomcat-NG：microsoft.public.dotnet.framework.aspnet
> ;
>在我的web.config文件中，我已指定Windows进行身份验证，inIIS>我已将其设置为集成身份验证。
>
>但是我的SQL连接仍然显示Anonymous。
>我还需要其他地方检查？
>
>谢谢
>
>
> Win 2003，SQL Server 2000
>
>
>

In my web.config file I''ve specified Windows for the authentication, in IIS
I''ve set it to Integrated Authentication.

But my SQL connection is still showing Anonymous.
Is there somewhere else I need to check?

Thanks
Win 2003, SQL Server 2000

解决方案

Tom,

What do you mean when you say that your SQL connection is still showing
anonymous?

Jim Cheshire [MSFT]
Developer Support
ASP.NET
ja******@online.microsoft.com

This post is provided as-is with no warranties and confers no rights.

--------------------

From: "Tom B" <sh*****@NOSPAMhotmail.com>
Subject: Integrated Authentication.
Date: Thu, 16 Oct 2003 11:19:41 -0400
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <#F**************@TK2MSFTNGP11.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: 216.46.141.98
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:184652
X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

In my web.config file I''ve specified Windows for the authentication, in IIS
I''ve set it to Integrated Authentication.

But my SQL connection is still showing Anonymous.
Is there somewhere else I need to check?

Thanks
Win 2003, SQL Server 2000

Well, I catch the error and write out the Message, which is.....

Login failed for user ''NT AUTHORITY\ANONYMOUS LOGON''.

and Profiler shows the same.
"Jim Cheshire [MSFT]" <ja******@online.microsoft.com> wrote in message
news:m2**************@cpmsftngxa06.phx.gbl...

Tom,

What do you mean when you say that your SQL connection is still showing
anonymous?

Jim Cheshire [MSFT]
Developer Support
ASP.NET
ja******@online.microsoft.com

This post is provided as-is with no warranties and confers no rights.

--------------------

From: "Tom B" <sh*****@NOSPAMhotmail.com>
Subject: Integrated Authentication.
Date: Thu, 16 Oct 2003 11:19:41 -0400
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <#F**************@TK2MSFTNGP11.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: 216.46.141.98
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:184652X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

In my web.config file I''ve specified Windows for the authentication, in IISI''ve set it to Integrated Authentication.

But my SQL connection is still showing Anonymous.
Is there somewhere else I need to check?

Thanks
Win 2003, SQL Server 2000

Tom,

Are you using SQL Server authentication or Windows authentication against
SQL Server? Sounds like you are using Windows, and in that case, you
either need to give the ASP.NET process account access to the SQL Server
database, or you need to impersonate.

Jim Cheshire [MSFT]
Developer Support
ASP.NET
ja******@online.microsoft.com

This post is provided as-is with no warranties and confers no rights.
--------------------

From: "Tom B" <sh*****@NOSPAMhotmail.com>
References: <#F**************@TK2MSFTNGP11.phx.gbl> <m2**************@cpmsftngxa06.phx.gbl>Subject: Re: Integrated Authentication.
Date: Thu, 16 Oct 2003 16:00:47 -0400
Lines: 55
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <ut**************@TK2MSFTNGP10.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: 216.46.141.98
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:184756
X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

Well, I catch the error and write out the Message, which is.....

Login failed for user ''NT AUTHORITY\ANONYMOUS LOGON''.

and Profiler shows the same.
"Jim Cheshire [MSFT]" <ja******@online.microsoft.com> wrote in message
news:m2**************@cpmsftngxa06.phx.gbl...

Tom,

What do you mean when you say that your SQL connection is still showing
anonymous?

Jim Cheshire [MSFT]
Developer Support
ASP.NET
ja******@online.microsoft.com

This post is provided as-is with no warranties and confers no rights.

--------------------

>From: "Tom B" <sh*****@NOSPAMhotmail.com>
>Subject: Integrated Authentication.
>Date: Thu, 16 Oct 2003 11:19:41 -0400
>Lines: 12
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>Message-ID: <#F**************@TK2MSFTNGP11.phx.gbl>
>Newsgroups: microsoft.public.dotnet.framework.aspnet
>NNTP-Posting-Host: 216.46.141.98
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP11.phx.gbl
>Xref: cpmsftngxa06.phx.gblmicrosoft.public.dotnet.framework.aspnet:184652 >X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
>
>In my web.config file I''ve specified Windows for the authentication, inIIS >I''ve set it to Integrated Authentication.
>
>But my SQL connection is still showing Anonymous.
>Is there somewhere else I need to check?
>
>Thanks
>
>
>Win 2003, SQL Server 2000
>
>
>

这篇关于集成认证。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！