February 14, 2008 at 6:03 pm
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
February 14, 2008 at 7:52 pm
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
February 14, 2008 at 8:00 pm
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