I would start a new thread for this issue. Please include what type of replication you are using and how it is configured.

Let me rephrase that a bit... domain1\dummyuser is a domain user. Administrator is not and can therefore authenticate.

You have 2 domains. Say you have domain1\user and domain2\user. Just because they are both named "user" does not mean they will authenticate properly. You cannot, without special cross-domain...

Cadavre (4/3/2012)

---

S_Kumar_S (4/3/2012)

---

Hi

I need a query(or function) that filter the names(column name) which have consecutive 3 alphabets. basically I want to filter out those garbage names. e.g. sabcmm has abc...

Anders Pedersen (4/3/2012)

---

Or don't use the maintenance plans to backup SQL and only save the date in the file name. That way don't need linked servers as long as the...

In my neverending search for knowledge... I found this article. Welsh, does this help at all?

http://www.webhostgear.com/204.html

Yup! Stepping away and observing because this is clearly not what I thought... 🙂

Hmm... Can you post the results of sp_configure?

Welsh Corgi (4/2/2012)

---

SQLKnowItAll (4/2/2012)

---

Looks to me like a permissions issue based on the error messages. Did you restart the service after you changed the login using SQL Server Configuration...

Looks to me like a permissions issue based on the error messages. Did you restart the service after you changed the login using SQL Server Configuration Manager? (Also, make...

Welsh Corgi (4/2/2012)

---

I changed the Account for the SQL Server and SQL Server Agent Account to an account that it should work with and tried to send a message but...

GilaMonster (4/2/2012)

---

SQLKnowItAll (4/2/2012)

---

However, enabling backup compression on top of data compression will not help much (since the data itself is already compressed and does not leave much to be compressed...

Doe it still hold true that on 2008 (not r2), backup compression can only be initiated on Enterprise edition and restored to any edition? This is in contrast to data...

Have you changed any of the service logins outside of SQL Server Configuration Manager? If you have, they may not have the required permissions...

Lynn Pettis (4/2/2012)

---

Grant Fritchey (4/2/2012)

---

Lynn Pettis (4/2/2012)

---

In SQL Server 2008 and newer...