Sunday, February 19, 2012

create endpoint with anonymous authentication (yukon)

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.

No comments:

Post a Comment