[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 557
  • Last Modified:

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

0
matrix_aash
Asked:
matrix_aash
  • 3
  • 3
1 Solution
 
reb73Commented:
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..

0
 
reb73Commented:
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
0
 
matrix_aashAuthor Commented:
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.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
matrix_aashAuthor Commented:
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

0
 
reb73Commented:
Actually, its your source server (version 9.00.1399.06) and not the target that's on RTM version..

See the following link to identify service pack details using version numbers -

http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185

Roll-up your source server to match that of target to facilitate mirroring..
0
 
St3veMaxCommented:
Also check that your SQL Server can "see" the mirror on the network.
0
 
matrix_aashAuthor Commented:
It can see the mirror server. I can ping it and I can access throught network from the principal server.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now