Is that a Named Instance and ar you suing the Servername\Instance name or the Servername\Port # where SQL is listening.

More info would only would be better to troubleshoot.

The Security context under which the Agent is configured, must not be having full rights to

'C:\Program Files\Microsoft SQL Server\MSSQL10.SSC20460\MSSQL\ReplData\unc\SSC20460$SSC20460_SANDBOX_PUBLISHER_MYTESTPUBLICATION\20091214101234.

Check that. Is it on Windows 2003 or Windows 2008?

Yes Ignacio, that link is to support that is infact AS for Analysis Server.

I am not an expert in that, I only create it only when necessary.

Instead, let me ask this, are you trying to create the Linked Server using the GUI? If...

Can you confirm that login is working with the pwd you are using in Linked Server, try using that login/pwd from another Server using SQL Server Authentication.

Look at this link here

That should not have any issue, you must be able to have Linked Server between different editions.

Check the Login you are using exists on the destination with the same password.

That error seems to be connection lost from the Server, have you re run the DBCC command again?

Please don't cross post. All responses are to be posted Here

I agree with Bitbucket

Please find some of them below.

http://www.sqlservercentral.com/articles/Clustering/65994/%5B/url%5D

http://www.sqlservercentral.com/articles/Clustering/66246/%5B/url%5D

GilaMonster (12/13/2009)

I saw the preview for that. Brought back some memories. I...

You got to write 2 exams 70-445 and 70-446.

RBarryYoung (12/12/2009)

RBarryYoung (12/12/2009)

... uhh, Mazda? Nissan? ...

Barry's turn for the 10,000th post

5 more posts and it will hit the 1000th Page and then the countdown begins to 10000th post 🙂