logged this with microsoft a while ago:

http://connect.microsoft.com/SQLServer/feedback/details/814236/the-distributer-has-not-been-installed-correctly-microsoft-sql-server-error-20036

not sure what the solution is as the replicated machine is clustered using SteelEye Lifekeeper and the network name is the machinename.

Hi Can some one assist,

I managed to find a few spare mins today looking into this problem.

I zoned in that the problem is relating to the sp_helpqreader_agent SP, and is...

SQL version is 10.50.4279 for the publisher

The distributer is 10.50.4000.

The SQL Database that is replicated is running in SQL 2000 Compatibility Mode and was upgraded recently from SQL 2000(replication was...

I setup replication on a test server with the same settings as live and found no error generating the scripts but did find that the link server error also occurred...

Hi Andreas,

I've checked the Servernames they are all correct. We do use aliases on our clustered environments etc but that shouldn't cause this problem as replication is working correctly. It's...

I think my problem is linked to the linked server DATA ACCESS, if we can get to the bottom of that then it should work as the generate scripts tries...

Hi Andreas, Thanks for the post, I ran the proc mentioned and it returns the name of the distribution server on the publisher, on the distribution server every thing is...

The second problem, when I go to test the connection of the linked server call repl_distributor which is setup by the distributer it is failing to connect properly ie ...

Does this have to be uploaded as an Excel file?, why not try .csv or .txt and then it should pull through?

FIXED!!!

Perseverance and we get there!.

The fix was as follows in my case:

Could connect using the [servername]\instancename but not using its alias.

SQL 2008 R2 Standard Edition x64 version

1) Open SQL...

You will need to read data from the COM+ Catalog:

http://msdn.microsoft.com/en-gb/library/windows/desktop/ms679168(v=vs.85).aspx

"The COM+ catalog provides a layer of abstraction over the actual details of where and how COM+ configuration data...

I encountered a similar problem and had some fun and thought it may help others.

When checking the endpoints check the names on both servers(or add the witness or any other...

after monitoring the above server for several weeks and with the addition of the monitoring i placed, this problem wasnt as easy or as straight forward as simply saying upgrade...

to follow up the data file for the database is 8.6GB but the log file is 2 MB as it is in Bulk-Logged mode and the Torn page detection and...

Fair points, Thanks for the responses.

I'll have to rework the proposals and see whether the customers are happy to stump up extra cash, the money parts usually the stumbler for...