Access to Integratiopn Services

  • I am setting up a home server and I have installed SQL Server 2005 SP2 onto a desktop running Windows XP Pro. At first I could connect from Mgt Studio from my other laptop so I figured out I had to go into Windows Firewall on my server and open port 1433. I still cannot connect to Integration Services on my server from a remote computer. The is a home network so there are no domain logins - just local to the respective computers. Can someone please outline the steps I need to take to enable user from remote computer to connect to my servers SSIS.

    Thanks

  • Chad, are you getting a specific error message?

    - Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford

  • Yes. "Connect to SSIS Service on machine "ServerName" failed. The RCP Server is unavailable"

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply