Generally, replication requires one server to 'reach out' to the other server and connect. If they are 'never' connected, how are you porting the databases from one system to...

OK... I've made progress. Now I'm getting Error 18456, successfully connecting to the server with a valid login, but have a server access failure. What settings do I...

Steve Jones - Editor (5/20/2008)

---

First, you shouldn't grant sysadmin privleges. That's a huge security hole and unnecessary.

When replication runs, the account on the distributor logs into SQL Server just like...

When I drilled down into the details of the log, and examined the SUBSEQUENT step, not the previous step as suggested in the log itself, I find this line:

2008-05-19 20:33:43.85...

OK, I went into the target server and granted syadmin privileges to the Windows login within SQL Server. Doing so made no difference in outcome - I still get...

In my event viewer on my workstation (event viewer on target server shows nothing), I receive the following message:

Replication-Replication Snapshot Subsystem: agent DELL4\BUYSPEED-FLETC-FirstTestForMerge-3 failed. The replication agent had encountered an...

Don't forget the classical problem whenever moving content from production to test - as part of your development work, you will change your database structures, and that can wreak havoc...

I'm no expert here, but it seems to me that using a Pull subscription from your target machines will be the most effective way to 'replicate' the databases, since they...

operating system?

Nicole (5/6/2008)

---

last weekend we had an upgrade, my data retrieval time from the replication server is extremely slow. a report that previously took maybe 15 seconds to return data is...

I'm sure there are better ways, but my got reaction is to create a new SS2k5 database at your central location to be the subscriber. Then you can locally...

It also sound, in reading the full thread, that you encountered an early error that is causing this problem, so that you're looking in the wrong place for the source...

JeremyVnc (4/16/2008)

---

Thanks for that. I don't totally understand the use of XACT_ABORT ON but when I used it and took off the distributed transaction, the code worked... all the...

Additional question: is this an occasional error or something that occurs 100% of the time?

search on phrases like 'date arithmetic' or 'date calculation' or 'date formatting' for ideas on how to solve your problem. multiple ways to solve your issue, and they've all...