Hi All,

My sql knowledge is very limited, but it would be very helpful to be able to collate this sort of information. I have ran the script and understand that...

Ill add this for the purpose of future viewings.

I have un-installed the Reporting Services from Add/Remove programs and this still did not correct the problem. Just to clarify, i have...

Thanks for your reply, i have rebooted server but this has done no good.

Thanks for your reply Rohan i shall get right on to reading the link you posted.

Thanks!

Thanks for both your replies.

andersg98 - yes they are both on the same domain.

Warren peace - Both the sql services are the same (local system). Ill pass the next stage...

Hi i've found your thread here and i am having the same problem, could you say how you resolved this please?

Thank you, you have answered my question with the 1st answer. I have found out that the 2nd query was an account created by the dev team and is ok...

Thanks for your reply Stewartc. Answers to your questions below.

1.Sql Server

2.My domain login account is on both servers with sysadmin rights.

3.Be made using the logins current security context.

Hope this...

Thanks for your reply. I have done both, checked the subscritpions and publishers on both server A & B and neither of them have replication setup. I have run the...

I had a similar problem whereby it was the folder that was the problem. Just try doing the backup straight to the C: drive and then run the delete command....

Hi, you may find it more helpful to carry out a restore from the probduction to the test using the backup. However when you would have set your replication up...

Thanks i will read this and feedback all my findings.:-)

Hi and thanks for your reply. I have checked the firewall and it is off. I have ensured that the user id that i have used when creating the linked...

Hi,

I have read through your questions and answers to your linked server setup issue.

I too am having a similar problem with two servers that i am trying to link together....

Hi steveb thanks for your reply it now works yay!!

Thank to everyone for your help!:-)