Mirroring Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Mirroring Error

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-01-13 : 07:01:41

Dear All,
I am new to administration task i was practicing the Mirroring in my local machine having one server with 3 instances.

I have enabled the Trace Flag by using DBCC TRACEON (1400) in principle server and mirror server in master database.
In spite of that i am getting the error

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
------------------------------

Please help me to resolve this issue.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-01-13 : 07:41:52

You have SQL 2005 RTM (the initial version with no service packs). Mirroring was disabled in the initial release of SQL 2005 and only enabled in service pack 1.

Download and apply Service pack 3 (the latest one), then you'll be able to set up the mirroring.

Edit: oh, and turn the trace flag off.

--
Gail Shaw
SQL Server MVP

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-01-13 : 08:56:18

Hi GilaMonster,
Thanks for your reply..

I have this version of SQL server 2005
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.1 (Build 2600: Service Pack 3)

I turned off TRACE flag again by using
DBCC TRACEoff (1400) on all the instance

Still I am getting the same error as posted earlier.

Can u pls help me

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-01-13 : 10:32:22

As I said, you have SQL 2005 RTM, the initial release with no service packs installed. Download and install service pack 3, and try the mirroring again. It's not going to work while you're running RTM of SQL 2005 (version 9.00.1399)

--
Gail Shaw
SQL Server MVP

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-01-13 : 11:29:53

Hi Gail,

If i run this query
SELECT SERVERPROPERTY('ProductVersion') i will get 9.00.4035.00

so which service pack is this ?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-01-13 : 15:15:43

That looks like SP3. Is that from the same instance as the SELECT @@version that you posted earlier? If so, there's something really odd going on.

Make sure that all the instances involved in the mirroring are patched, preferably to the same level

--
Gail Shaw
SQL Server MVP

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-01-14 : 01:28:25

Yes Gail..
In all the instance SP3 is patched ..

I am using default check point name i.r "Mirrorring"
Can u please somebody help m e to set up service account which is the last step of mirroring wizard.
I am leaving this as a blank.

Any help in this regard highly appreciated

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources