Эти коварные "конечные точки"

????????? ??? ???????????? ? ????????? – ? ?????-?? ?????? ???????????? ?????? ????? login-? ? SQL Server. ??????? ??????? ?????? – ????????? ????, ???????? login-? – ? ???????????? ???????? ?????? “Login failed”.

? ??? ???? ???????, ? ??? ???????, ? ??????? ???? ????…

?????????? ????????? ????????:

1) ?? ???????? ????? ???????? ????? ??? TCP:

CREATE ENDPOINT tcp_endpoint

    STATE = STARTED

    AS TCP(LISTENER_PORT = 7022)

    FOR TSQL()

   GO

      ??? ???? ?? ????????? ????????? ??????????????:

«Creation of a TSQL endpoint will result in the revocation of any 'Public' connect permissions on the 'TSQL Default TCP' endpoint. If 'Public' access is desired on this endpoint, reapply this permission using 'GRANT CONNECT ON ENDPOINT::[TSQL Default TCP] to [public]'.»

?????? ????? ??????? ?????????, ??? ??? ?????????????? ???????? ??? ???????? J

2) ????? ?????-?? ????? ?? ???????? ??????? ????????? ???????? ?????:

DROP ENDPOINT tcp_endpoint

GO

? – ???????, ??????? – ? ??? ?????????? ???????? ? ?????????????? ????????????.

??? ?????????…

?? ?????????, ? SQL Server ?????????? ???????? ????? ??? ???? ??????????:

?? ????????? ??, ????????? ???? public (??? ?????? ??????????? ???? ????) ????? ????? ???????????? ????? ??? ???????? ?????. ?.?., ???? ???????????? ???????? ??????????? ? SQL Server, ????????, ???????? TCP\IP, ?? ????? ??????????? ????? ???????? ????? [TSQL Default TCP] ? ?????? ????? ??????????????? ?????. ??? ? ??? ???????, ?? ????????? ?? ?? ?????, ?.?. ??????????? ????????? ???? public, ???????, ? ???? ???????, ????? ????? ??????????? ????? ????????? ???????? ?????.

????? ?? ???????? ????? ???????? ????? ??? TCP ?????????, ????? public ?? ????????? ???????? ????? ??????????, ??, ????? ?? ??? ????? ????? ????????, ??? ?? ???????????? (? ???, ??????????, ? ??????? ??????????????, ??????????? ????). ????? ???????, ????????? ???? public ?? ????? ?????? ???? ???????????, ????????? ???????? TCP\IP.

??? ??????????…

Errorlog ????? ????????? ?????? «Login failed» ?? ???????? 11 ??? 12. ????????:

2009-05-22 18:33:25.78 Logon Error: 18456, Severity: 14, State: 12.

2009-05-22 18:33:25.78 Logon Login failed for user 'lgn_valid'. Reason: Login-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ...]

????????? ?????? ?????????? ?????? ???????? ?????, ????? ??????????? ????? ??????? ???? public:

Select sp.permission_name, sp.state_desc, ep.name

from sys.server_permissions sp join sys.endpoints ep

      on sp.major_id = ep.endpoint_id

where sp.grantee_principal_id = 2 and sp.class = 105

GO

? ????? ??????? ????????? ????? ?????:

CONNECT GRANT TSQL Local Machine

CONNECT GRANT TSQL Named Pipes

CONNECT GRANT TSQL Default VIA

??? ?????, ???????? TCP ??????????? ? ??????.

??? ?????????…

????? ??????? ????? ??????????? ????? ?????? ???????? ????? ????????? ???? public:

GRANT CONNECT ON ENDPOINT::[TSQL Default TCP] to public

GO