Error: 16955, Severity: 16, State: 2

When I used sql profiler to trace exception error of my sql server, I got a
bunch of error 16945,16955 and 208, I wonder if anyone knows how could I
locate where the error raised?
Thanks.Check if the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;302477 applies to
your case.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"davidw" <wyx1999@.hotmail.com> wrote in message
news:OA#1t6xVDHA.2100@.TK2MSFTNGP11.phx.gbl...
> When I used sql profiler to trace exception error of my sql server, I got
a
> bunch of error 16945,16955 and 208, I wonder if anyone knows how could I
> locate where the error raised?
> Thanks.
>

error while doing mirroring

I got the following error log from SQL profiler when I tried to start mirroring

"

2006-11-10 11:54:47.28 Logon

Database Mirroring login attempt by user 'NT AUTHORITY\ANONYMOUS LOGON.' failed

with error: 'Connection

handshake failed. The login 'NT

AUTHORITY\ANONYMOUS LOGON' does not have CONNECT permission on the endpoint.

State 84.'. [CLIENT: 10.77.100.86]"

Anybody knows the solution for the same please let me know

Hi,

What is login account your SQL Server start?

Account is the same in both?

Regards,

|||Account is the same in both the SQL servers.|||

I would suggest delete both endpoints in both servers

re-run the Mirror Wizard, give it the AD domain username again, and it'll create the endpoints for you

or it probably uses the authentication you're using when you create the mirror

or try this

/****** Object: Endpoint [Mirroring] Script Date: 11/13/2006 10:31:45 ******/

CREATE ENDPOINT [Mirroring]

AUTHORIZATION [DOMAIN\username]

STATE=STARTED

AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)

FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE

, ENCRYPTION = DISABLED)