asked on

Database Mirroring Setup Error

Hi All,

I am try to setup database mirroring between two sql server but it comes up with the below error:

Pricipal Server Version is :
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Mirror Server Version is :
Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

Cannot see anything wrong from SQL Server version point of view but still getting this error of setting up flag.

Thanks in advance.

Cheers

TITLE: Microsoft SQL Server
------------------------------
 
SQL Server cannot create the mirroring endpoint, 'Mirroring'.
 
------------------------------
ADDITIONAL INFORMATION:
 
Create failed for Endpoint 'Mirroring'.  (Microsoft.SqlServer.Smo)
 
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Endpoint&LinkId=20476
 
------------------------------
 
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
 
------------------------------
 
Database mirroring is disabled by default. Database mirroring is currently provided for evaluation purposes only and is not to be used in production environments. To enable database mirroring for evaluation purposes, use trace flag 1400 during startup. For more information about trace flags and startup options, see SQL Server Books Online. (Microsoft SQL Server, Error: 1498)
 
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=1498&LinkId=20476
 
------------------------------
BUTTONS:
 
OK
------------------------------

Open in new window

reb73

You are probably using a RTM version in your x64 mirroring target which has the mirroring disabled by default..

Download and apply SP1 on the x64 target box, which should fix your problem..

reb73

You can also enable mirroring in the as-is version by using trace flag1400 (-T 1400) in your service startup options ..

See following link on configuring server startup options -

http://msdn.microsoft.com/en-us/library/ms345416(SQL.90).aspx

matrix_aash

ASKER

But I thought you dont need to enable mirroring if its more than service pack 2 which I think I have on both the servers.
AS far as my knowledge goes they are productions licence.

How can I find out whether it is RTM version or not ?

Cheers.

matrix_aash

ASKER

I have managed to enable it with the flag and now I am stuck on the below error any ideas ?

TITLE: Database Properties
------------------------------
 
An error occurred while starting mirroring.
 
------------------------------
ADDITIONAL INFORMATION:
 
Alter failed for Database 'FirebirdSubscriptions'.  (Microsoft.SqlServer.Smo)
 
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476
 
------------------------------
 
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
 
------------------------------
 
The server network address "TCP://ashish.airclaims.co.uk:5022" can not be reached or does not exist. Check the network address name and reissue the command. (Microsoft SQL Server, Error: 1418)
 
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476
 
------------------------------
BUTTONS:
 
OK
------------------------------

Open in new window

ASKER CERTIFIED SOLUTION

reb73

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

St3veMax

Also check that your SQL Server can "see" the mirror on the network.

matrix_aash

ASKER

It can see the mirror server. I can ping it and I can access throught network from the principal server.