Did an upgrade today from SQL Server 2008 R2 CTP [community technical preview] evaluation software to the final RTM [release to manufacturing] version. One thing l noticed – l cant find a service for SSIS – Sql server integrated services – under the usual list of SQL services using SCCM – SQL server configuration manager. [...]
On a new instalaltion of SQL Server 2008, running on Windows Server 2008, l cannot connect to SSIS from SSMS (Sql server management console) 2008 running on a client workstation. I can connect from the local server end. I tried adding the users Group to the permissions option on Component Services/MsdtsServer100 as suggested by many [...]