creating db mirroring endpoints

[FALCONSEYE]

I was running the following:

CREATE EndPoint xxxx
STATE = Started
AS TCP (LISTENER_PORT = 5022)
FOR DATABASE_MIRRORING (ROLE=PARTNER)

and got this error message:

Msg 1498, Level 16, State 2, Line 4
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.

After googling around, I came across couple links indicating I should install service pack 1 to get rid of this problem. However, the server already has service pack 2 installed. Is there something else I can do?
thanks

http://www.jetansolutions.com

 

[FALCONSEYE]

By the way, I am trying to create the mirroring endpoint on the instance2. The same query worked on instance1.
Also, found this link:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3104216&SiteID=17

When I right click on the instance > properties > advanced , I don't see a place to modify the start up parameters for:-T1400

any help?

http://www.jetansolutions.com

 

[FALCONSEYE]

nevermind. Once I stopped the sql instance 2, and run this :

net start xxxx /t1400 , i was able to create the endpoint.

http://www.jetansolutions.com

 

[olahallengren]

>After googling around, I came across couple links indicating I should install service pack 1 to get rid of this problem. However, the server already has service pack 2 installed. Is there something else I can do?
thanks

There is something that isn't right here. If you're on SP2 you shouldn't get this error message and you shouldn't need the trace flag.

Could you run a SELECT @@VERSION and post the result here?

Ola Hallengren

http://ola.hallengren.com

 

[FALCONSEYE]

Thanks Ola,
That's how i know that I am on sp2.

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

http://www.jetansolutions.com

 

[olahallengren]

I think that you should contact MS Support. You should not need a trace flag to run database mirroring with SP2.

Ola Hallengren

http://ola.hallengren.com