Local System Account

Hi...

thx for the reply...

I have used both server and windows authentication.

When I am using server authentication,I have created a certificate and used authentication=certificate in...

hi ...

thx for the reply....

When I see the errorlog,the error msg was

" Error: 18456, Severity: 14, State: 11.2009-03-19 17:59:50.29

Logon ...

hi....

WHEN i USE WINDOWS AUTHENTICATION FOR DATABASE MIRRORING iT GIVES ME ERROR MSG

"Cannot connect to MSSQL\MSSQL08.

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

ADDITIONAL INFORMATION:

Failed to connect to server MSSQL\MSSQL08. (Microsoft.SqlServer.ConnectionInfo)

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

Login failed for user...

HI...

I HAVE TRIED MIRRORING BY CREATING THE CERTIFICATE

i HAVE RUN THE FOLLOWING CODE(BOTH ON PRIMARY AND MIRROR SERVER)

--use master

--go

--create master key encryption by password='PASSWORD';

--GO

--CREATE CERTIFICATE MSSQL_CERTIFICATE...

Hi..

WHEN i SEE THE ERRORLOG,the message on the primary server errorlog was

An error occurred while receiving data: '10054(An...

the mirror db in recovery mode

hi...

thx for the reply..

The sys.tcp_endpoints shows the ports both on primary and mirror server.

The endpoints are started in sys.database_mirroring_endpoints.

but when I use netstat on...