Manually I created logins with same passwords in secondary server. I totally configured secondary server same as primary server. and had setup logshipping for user databases(restored user db's in standby...

No. but same logins and permission are in DR server whatever production has

chk2009 (11/13/2009)

---

Steve Jones - Editor (11/13/2009)

---

The error shows you are connecting with named pipes. You might have something changed in your SSMS connection dialog. Double check all settings that you...

Steve Jones - Editor (11/13/2009)

---

The error shows you are connecting with named pipes. You might have something changed in your SSMS connection dialog. Double check all settings that you are...

Steve Jones - Editor (11/13/2009)

---

HOW are you connecting? SQL Auth, Windows Auth, what are you typing in SSMS? That is some of the information we need to help you solve...

We have two servers

production and DR server(planning to set up logshipping)

In both servers sql server std edition is installed, both are in same workgroup and no firewall and all...

Steve Jones - Editor (11/12/2009)

---

It's a connection issue as stated. Can you connect from another workstation/client? Are you allowing connections remotely? What protocol are you using, and how are you...

lmu92 (11/10/2009)

---

What do you mean by "XL file"?

Is it a typo meaning XML structure or do you want to store an "eXtra Large" file?

If the former, please search for "XML...

Thanks for your reply:-)

How can we do that, can you pls explain me in...

Can we take tail tlog backup even when db is offline/damaged/correpted

Lynn Pettis (11/3/2009)

---

People still have pagers??

If you already have the pager(s) check with the company and see if you can send email alerts via them. Many years ago at...

Thank you -CirquedeSQLeil and Gila monster

Issue has been resolved.

One windows service is taking more memory. This service runs daily 12Pm, basically it connects to external client system it downloads ftp...

@CirquedeSQLeil

No jobs are failed

No blockings

No long running queries

I checked perfmon counters. Pages/sec and avg disk counters reaching to 80-100 some time.

@gila master

Thanks for your reply, yes I want to reduce...

@Marcin Gol

Thank you for reply.

If you can provide the steps/process using Benchmark Factoy tool, I appriciate it. Thanks once again

I need to test SQL Database performance and user...

@free_mascot

Thank you for your reply.

Can we capture user connection load with SQL Profiler, if so please let me know the how to capture.

----

And I came accross a solution,...