http://clusteringformeremortals.com/2009/10/07/step-by-step-configuring-a-2-node-multi-site-cluster-on-windows-server-2008-r2-%E2%80%93-part-3/

Drop the job and prepare a new one

can you make it clear te purpose to know.I'm having three DB server on same machine:-D

Try using windows authentication

https://blogs.msdn.com/b/psssql/archive/2009/05/12/sql-server-reports-working-set-trim-warning-message-during-early-startup-phase.aspx

Refer above URL....it might help you

USE AdventureWorks2008R2;

GO

--Set the options to support indexed views.

SET NUMERIC_ROUNDABORT OFF;

SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,

QUOTED_IDENTIFIER, ANSI_NULLS ON;

GO

--Create view with schemabinding.

IF OBJECT_ID ('Sales.vOrders', 'view') IS NOT NULL

DROP VIEW...

Refer the above page 😀

Ratheesh,

😀

Can you specify what kind of job ????

????????????:w00t:

What made you think on this ???????:discuss:

Jobychetta,

u too

Ratheesh,

We are using windows authentication for login.

Its a windows 2003 server holding an sql2005 enterprose edition.

Its a very critical production server.

We are having windows authentication with full privileges on that...

For what you need to synchronize.Can you specify it clearly.....

Try using third party tools...

Yes ofcourse.You can !!!