Problems connecting to SSIS in SQL Management Studio
I tried to conect to SSIS and got the error “SQL-server does not allow remote connections”(rougly from the top of my head). Turned out that the server i was connecting to needed SSIS to be confugured to run against a specified instance of SqlServer.
SSIS runs as standard at the default instance (i.e localhost). this is configured in the file :”%ProgramFiles%\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml”.
Change ServerName to the correct instance.
<Folder xsi:type="SqlServerFolder"> <Name>MSDB</Name> <ServerName>servername\sql2005</ServerName> <!-- This was the original line <ServerName>.</ServerName> --> </Folder>
Links
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=105166 (at the end of the page)
Get more info on:
http://searchsystemschannel.techtarget.com/generic/0,295582,sid99_gci1248754,00.html
(Good info on deployment)
