Did you try to connect using DAC?

http://msdn.microsoft.com/en-us/library/ms189595.aspx

EnjoY!

why don't you use SQL service domain account for both servers. May be SA password on publisher and Subscriber is not same.

EnjoY!

majidkhanme (2/16/2010)

---

Hello all,

I am oracle dba and now i have a sql server 2005 database i need to manage! I got pretty much all basic admin stuff figured out.

Can...

RBarryYoung (2/16/2010)

---

GT-897544 (2/16/2010)

---

RBarryYoung (2/16/2010)

---

Possible, but I don't think so in this case.

That kind of person is a "Troll" and they are not hard to spot once you know what to...

RBarryYoung (2/16/2010)

---

GT-897544 (2/16/2010)

---

Elliott W (2/16/2010)

---

Alvin Ramard (2/16/2010)

---

CirquedeSQLeil (2/16/2010)

---

I don't get the impression that he is backing down at all from his position. He says he agrees, but I don't...

GSquared (2/16/2010)

---

GT-897544 (2/16/2010)

---

Elliott W (2/16/2010)

---

Before you get into a dander any further. I have a couple questions, has this actually happened to you and how did you solve it?...

RBarryYoung (2/16/2010)

---

tstaker (2/16/2010)

---

CirquedeSQLeil (2/16/2010)

---

I don't get the impression that he is backing down at all from his position. He says he agrees, but I don't get the impression that...

Elliott W (2/16/2010)

---

Before you get into a dander any further. I have a couple questions, has this actually happened to you and how did you solve it? On...

GSquared (2/16/2010)

---

tstaker (2/16/2010)

---

CirquedeSQLeil (2/16/2010)

---

I don't get the impression that he is backing down at all from his position. He says he agrees, but I don't get the impression that...

GSquared (2/16/2010)

---

GT-897544 (2/16/2010)

---

Elliott W (2/16/2010)

---

This whole post makes me laugh..

Basic Troubleshooting 101:

1. Find out WHY you have the problem in the first place

It is clear that GT-897544 has very little...

Elliott W (2/16/2010)

---

Alvin Ramard (2/16/2010)

---

CirquedeSQLeil (2/16/2010)

---

I don't get the impression that he is backing down at all from his position. He says he agrees, but I don't get the...

The problem is some people are called DBA's, But they can't take any action until Gail or Paul post a solution.:-D

EnjoY!

Elliott W (2/16/2010)

---

GT-897544 (2/16/2010)

---

Elliott W (2/16/2010)

---

This whole post makes me laugh..

Basic Troubleshooting 101:

1. Find out WHY you have the problem in the first place

It is clear that GT-897544 has very...

I agree Gail, Only thing made to reply was when you all said data extract is not possible with suspect database. Because i came across those situations. My apologies if...

Elliott W (2/16/2010)

---

This whole post makes me laugh..

Basic Troubleshooting 101:

1. Find out WHY you have the problem in the first place

It is clear that GT-897544 has very little real world...