July 14, 2011 at 2:43 pm
I am getting error:
Msg 1486, Level 14, State 44, Line 1
Database Mirroring Transport is disabled in the endpoint configuration.
I did al the recommendations and still have the issue, the issue was not present on SP2 or earlier.
July 14, 2011 at 2:52 pm
Have you checked for encryption?
Does the service account have adequate permissions?
Was Mirroring already established prior to installing sp4?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 15, 2011 at 8:44 am
I am using this script to create endpoint:
CREATE ENDPOINT [SPTY11A_EndPoint]
AUTHORIZATION [VERDMONT\esteban brown]
STATE=STARTED
AS TCP (LISTENER_PORT = 7022, LISTENER_IP = ALL)
FOR DATA_MIRRORING (ROLE = WITNESS, AUTHENTICATION = WINDOWS NEGOTIATE
, ENCRYPTION = REQUIRED ALGORITHM RC4)
Yes, mirror was working prior to SP4
July 15, 2011 at 9:53 am
do you have PORT = 7022 open between the two servers?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 15, 2011 at 10:14 am
Yes
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply