Hello.
I am trying to remotely connect to SSIS from my PC using windows authentication in SQL mgmt studio and I keep getting the following error message:
Cannot connect to <server>
Additional Information:
Failed to retrieve date for this request. (Microsoft.SqlServer.SmoEnum)
Connect to SSIS service on machine "<server>" failed: The RPC server is unavailable.
I do not get the same error when I connect to the database engine, just SSIS. I don't have a firewall inbetween the machines either so it can't be that.
Has anyone else had a similar problem? if so, I would be grateful if you can you tell me how you got around it
Thanks
See this thread where I answered a similar question regarding not being able to connect to SSIS from Management Studio, I'm assuming this may be your problem:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=254204&SiteID=1
HTH
|||I get the same RPC error, but one of my co-workers doesn't get the error, and he can connect to SSIS from his desktop, but I cannot. I assume I don't need to change the .i' GAD 0l3/2e3/2 006o Rn the server since he has no problem connecting.
Any other ideas ?
No comments:
Post a Comment