Hi Perry Whittle,

Thanks for the reply.Problem has been fixed.

I have configured database mirroring different workgroups.In domians we can configure very easily, but in workgroups we have to open the endpoints...

HI Gail,

Thank you for the relpy.If i change to CHECKSUM suddenly any effects will happen .

HI Paul,

That was good aritcal.In My servers database defultly kept in PAGE_VERIFY =NONE ; which is the best option on both

torn_page_detection vs checksum.

Please advise me

Now i understood the concept.Thank you for the reply "Gail Shaw

"

but how it has been changed sql server 9.0.5000 to 9.0.5057 .is there any effect.

I got some information from C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Summary.txt

Time: 07/03/2011 12:43:10.877

KB Number:...

SKYBVI (6/22/2011)

---

maybe one of the trn files are (not copied/deleted) and so it keep on searching for that file as it cant apply other files...

Reapplying log shipping on tht...

Brandie Tarvin (6/15/2011)

---

You do realize this is the worst way to post a question, right? Gail has a day job, just like...

Thank you Muthukkumaran.i will utilize this procedure.

Bye

Steve-3_5_7_9 (6/15/2011)

---

To clarify, when you connect via SA are you using the same "screen print", SSMS, that you posted or is this local on the server?

...and both servers are in...

muthukkumaran Kaliyamoorthy (6/15/2011)

---

i second that grant. Alert is good option but it's not work all the cases.

If you want you can use my beat version Sproc and add the errors...

Thanks for the...

Hi,

Because In my company I am only SQL...

Steve-3_5_7_9 (6/14/2011)

---

To me this is more indicative of network, or AD than failed login since you are not seeing anything in the SQL Log. A failed login would show...

Steve-3_5_7_9 (6/14/2011)

---

What does your SQL Server log show?

Is it showing a "failed login"? "Login failed for user"?

To me it seems as though you're not getting to the database server...

Hi Gail & Brandie,

Now i understood the issue.Thank you the great answer