Is there a firewall between the two servers?

Well I changed the connection in the package to a windows account and now it works by the proxy, however I don't know why it wasn't working using a SQL...

Oh right - thanks very much 🙂

Hi all - This has happened again, I can only assume its a network issue at that time, something thats hard to capture unless I know when its happening.

Its strange...

Thanks for that, the powershell blog looks good

I just did a quick read of this:

http://msdn.microsoft.com/en-gb/library/hh213080.aspx#CreateAddiitListener

However if using 2 static IPs of different subnets and you use the listener name in your connection string, then the client you...

OK thanks to both for clearing that up, I will do more reading around checkpoints to.

I just wanted to let you all know that I implemented the solution and it works a treat as the previous poster says many thanks to Barry and Itzik.

Yes the remote connections is working ok, not sure putting my PC in the same OU as the server will have any impact. We are now looking at another...

Hi - I have got the networks guys to monitor blocked traffic on the firewalls and there is none for the defined port from my workstation. I know we...

Have tried from another server and the connection worked fine which would indicate the browser service is ok. I have no local firewall turned on am stumped at...

yeah browser service is started and UDP 1434 is open 🙁

Crickey guys thanks very much for all the replies, I will delve properly into them tomorrow when back at work, I decided to give myself a weekend off this week...

Hi all - thanks for the replies. I found that the problem was an authentication issues when adding the linked server, once I had resolved the security context and...

yes apologies you are right, however its still doesn't work. By this I mean I get an error of:

Msg 7202, Level 11, State 2, Line 1

Could not find server...