Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Mirror Error Msg 1418


Database Mirror Error Msg 1418

Author
Message
KTD
KTD
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 373
Hi, I have setup many mirrored databases before but this time has been very frustrating. I did search this error all day and nothing I have found has resolved my issue.
Of course I restore the full and all transaction logs leaving it in recovery.

I hope I can make this make sense. This is what I have checked.

First the security. Both use the same domain account.
I made both accounts SA and ADmin on the box to eliminate that as an issue.
Before that I had granted it Connect.

GRANT CONNECT on ENDPOINT::Mirroring TO xxx\xxx
GO


Confirmed by

SELECT EP.name, SP.STATE,
CONVERT(nvarchar(38), suser_name(SP.grantor_principal_id))
AS GRANTOR,
SP.TYPE AS PERMISSION,
CONVERT(nvarchar(46),suser_name(SP.grantee_principal_id))
AS GRANTEE
FROM sys.server_permissions SP , sys.endpoints EP
WHERE SP.major_id = EP.endpoint_id
ORDER BY Permission,grantor, grantee;
GO



Both Endpoints exist and the port is open and listening confirmed with netsstat and telnet to the port.

select * from sys.database_mirroring_endpoints


I also made sure again they were started even though it reports they were.

ALTER ENDPOINT Mirroring
STATE = STARTED
AS TCP (LISTENER_PORT = 5022)
FOR database_mirroring (ROLE = ALL);
GO



I checked the SPN existed on both servers and it list them.

Setspn.exe -L <ComputerName>



So I start the mirror and it fails

First on the mirror. This works
ALTER DATABASE xxxx
SET PARTNER =
'TCP://xxxxx:5022'

GO

Then
ALTER DATABASE xxxx
SET PARTNER =
'TCP://xxxxx:5022'
GO

This fails with the error 1418


Any help is appreciated.

I don't always test my SQL scripts, but when I do, I test in Production.
Chandra Sekhara Vyas Dhara
Chandra Sekhara Vyas Dhara
Hall of Fame
Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)

Group: General Forum Members
Points: 3963 Visits: 1149
Please check the following URL:

http://blogs.msdn.com/b/grahamk/archive/2008/12/08/database-mirroring-error-1418-troubleshooter.aspx



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search