September 16, 2010 at 4:36 am
Environment:Microsoft SQL Server 2005 - 9.00.1399.06
Standard Edition on Windows NT 5.2
(Build 3790: Service Pack 2)
I am able to enable the Trace Flag 1400 using DBCC TRACEON (1400,-1) . Only then we can able to configure for the ENDPOINTS.
I successfully configured the ENDPOINTS for both the principal server and Mirror server .And then when I started the START MIRRORING.
I got the error message. Please find the Message below.
An error occured while starting mirroring.
additional Information:
:..>Alter failed for Database 'TestDB', (Microsoft SqlServer.Smo)
:..>An exception occured while executing a Transact-SQL statement or batch
[Microsoft SqlServer.Connection.info]
:..>Database mirroring Transport is disabled in the endpoint configuration.
[Microsft SQL Server,Error: 1486]
NOTE: Both principle & mirror are running under same domain account having all Privileges
I have set Trace Flag 1400 "-T1400;..." in startup configuration options, rebooted and restarted servers and still not able to mirror.It Also given the error "Database Mirroring Transport is......
configuraiton
------------
Primary:
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 = REQUIRED ALGORITHM RC4)
Mirror:
CREATE ENDPOINT [Mirroring]
AUTHORIZATION [domain\username]username having all Privileges
STATE=STARTED
AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)
FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE
, ENCRYPTION = REQUIRED ALGORITHM RC4)
September 16, 2010 at 12:05 pm
Trace Flag 1400 should be enabled only in you are using RTM edition of SQL Server 2005.
Starting from SP1 and above, Trace Flag needn't be enabled for the sake of DBMirroring.
Thank You,
Best Regards,
SQLBuddy.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply