Hello, All!
The question to MSFT. Can you answer once and for all, will the sql server
2005 support anonymous authentication for endpoints? I have two BOLs, where
claims the different. This one:
AS HTTP (
PATH = 'url'
, AUTHENTICATION =( { BASIC | DIGEST | INTEGRATED } [,...n])
, PORTS = ({CLEAR | SSL} [,... n])
[ SITE = {'*' | '+' | 'webSite' },]
[, CLEAR_PORT = clearPort ]
[, SSL_PORT = SSLPort ]
[, AUTH_REALM = { 'realm' | NONE } ]
[, DEFAULT_LOGON_DOMAIN = {'domain' | NONE } ]
[, RESTRICT_IP = { NONE | ALL } ]
[, COMPRESSION = { ENABLED | DISABLED } ]
[, EXCEPT_IP = ( { <4-part-ip> | <4-part-ip>:<mask> } [,...n] )
)
and this
AS HTTP (
PATH = 'url'
, PORTS = ({CLEAR | SSL} [,... n])
[ SITE = {'*' | '+' | 'webSite' },]
[, CLEAR_PORT = clearPort ]
[, SSL_PORT = SSLPort ]
, AUTHENTICATION =({ANONYMOUS | BASIC | DIGEST | INTEGRATED} [,...n])
[, AUTH_REALM = { 'realm' | NONE } ]
[, DEFAULT_LOGON_DOMAIN = {'domain' | NONE } ]
[, RESTRICT_IP = { NONE | ALL } ]
[, COMPRESSION = { ENABLED | DISABLED } ]
[, ADD EXCEPT_IP = ( { <4-part-ip> | <4-part-ip>:<mask> } [,...n] )
[, DROP EXCEPT_IP = ( {<4-part-ip> | <4-part-ip>:<mask> } [,...n] )
)
Who is right?
With best regards, Alex Shirshov.
We will NOT be supporting ANONYMOUS authentication. I will file a bug to
correct BOL if there is indeed a reference to it.
We do not support ANONYMOUS in Beta2 as well.
Srik
"Alex Shirshov" <nomail@.mail.ru> wrote in message
news:eD$Jp6qsEHA.2560@.TK2MSFTNGP14.phx.gbl...
> Hello, All!
> The question to MSFT. Can you answer once and for all, will the sql server
> 2005 support anonymous authentication for endpoints? I have two BOLs,
> where
> claims the different. This one:
> AS HTTP (
> PATH = 'url'
> , AUTHENTICATION =( { BASIC | DIGEST | INTEGRATED } [,...n])
> , PORTS = ({CLEAR | SSL} [,... n])
> [ SITE = {'*' | '+' | 'webSite' },]
> [, CLEAR_PORT = clearPort ]
> [, SSL_PORT = SSLPort ]
> [, AUTH_REALM = { 'realm' | NONE } ]
> [, DEFAULT_LOGON_DOMAIN = {'domain' | NONE } ]
> [, RESTRICT_IP = { NONE | ALL } ]
> [, COMPRESSION = { ENABLED | DISABLED } ]
> [, EXCEPT_IP = ( { <4-part-ip> | <4-part-ip>:<mask> } [,...n] )
> )
> and this
> AS HTTP (
> PATH = 'url'
> , PORTS = ({CLEAR | SSL} [,... n])
> [ SITE = {'*' | '+' | 'webSite' },]
> [, CLEAR_PORT = clearPort ]
> [, SSL_PORT = SSLPort ]
> , AUTHENTICATION =({ANONYMOUS | BASIC | DIGEST | INTEGRATED} [,...n])
> [, AUTH_REALM = { 'realm' | NONE } ]
> [, DEFAULT_LOGON_DOMAIN = {'domain' | NONE } ]
> [, RESTRICT_IP = { NONE | ALL } ]
> [, COMPRESSION = { ENABLED | DISABLED } ]
> [, ADD EXCEPT_IP = ( { <4-part-ip> | <4-part-ip>:<mask> } [,...n] )
> [, DROP EXCEPT_IP = ( {<4-part-ip> | <4-part-ip>:<mask> } [,...n] )
> )
> Who is right?
> With best regards, Alex Shirshov.
>
|||Hello, Srik!
You wrote on Fri, 15 Oct 2004 15:47:28 -0700:
[Sorry, skipped]
Ok. Thank you. BTW, I have a beta 2 build 790 and it does support anonymous.
If the sql server will not support anonymous authentication, than how can I
connect to it without special settings on client? At first, I have to have a
public key of the certificate. But is ok, and really sad think, what I must
have windows account on server machine and must pass the credentials through
http. I don't understand, what the windows authentication need for? Is this
http.sys special requirement?
With best regards, Alex Shirshov.
|||Er... You say that "and it does support anonymous."
It shouldn't. If it does, then it is a bug. Can you email me the row from
the sys.endpoints and sys.soap_endpoints tables for an endpoint where anon
access is working?
Thanks!
Joel
"Alex Shirshov" wrote:
> Hello, Srik!
> You wrote on Fri, 15 Oct 2004 15:47:28 -0700:
> [Sorry, skipped]
> Ok. Thank you. BTW, I have a beta 2 build 790 and it does support anonymous.
> If the sql server will not support anonymous authentication, than how can I
> connect to it without special settings on client? At first, I have to have a
> public key of the certificate. But is ok, and really sad think, what I must
> have windows account on server machine and must pass the credentials through
> http. I don't understand, what the windows authentication need for? Is this
> http.sys special requirement?
> With best regards, Alex Shirshov.
>
>
|||Hello, Joel!
You wrote on Wed, 20 Oct 2004 13:39:11 -0700:
JS> It shouldn't. If it does, then it is a bug. Can you email me the row
JS> from the sys.endpoints and sys.soap_endpoints tables for an endpoint
JS> where anon access is working?
I try to send the screen shot to JoelSoderberg <at>
discussions.microsoft.com, but get an error. For newsgroup the picture is
too large.
Here is restricted output
[sql]
select cast(name as varchar(28)) name,is_anonymous_enabled from
sys.http_endpoints
select @.@.version
/*
alter endpoint secure
as http(
path='/sql/secure',
ports=(ssl),
AUTHENTICATION=(anonymous)
)
*/
[/sq]
name is_anonymous_enabled
-- --
hello_world_endpoint 0
secure 1
HelloFromYukon 0
_1 0
(4 row(s) affected)
----
Microsoft SQL Server Yukon - 9.00.790 (Intel X86)
Apr 12 2004 18:41:04 2000.090.0790.00
Copyright (c) 1988-2003 Microsoft Corporation
"Yukon" Beta 2 on Windows NT 5.2 (Build 3790: )
(1 row(s) affected)
[Sorry, skipped]
With best regards, Alex Shirshov.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment