Access Denied to remote SSIS

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello all;

We recently upgraded from SQL 2005 to 2008. In doing so, I lost my
connection to SSIS. It happened before and we solved it by the following
steps:

- If the user running under non-admin account it needs to be added
to Distributed COM Users group
- Run %windir%\system32\Com\comexp.msc to launch Component Services
- Expend Component Services\Computers\My Computer\DCOM Config
- Right click on MsDtsServer node and choose properties
- In MsDtsServer Properties dialog go to Security page
- Configure your settings as described
- Restart SSIS Service
(posted by autor Kirk Haselden and others on sqljunkies.com)

But this time it did not help. Is there an issue with 2008?
Any other ideas out there?

Thanks in advance.
--
Todd C
.

Relevant Pages

  • how to know about connection
    ... application is running if sql service is restarted then connection will ... lost(.(execute() function of sqlapi says connection is lost). ...
    (microsoft.public.sqlserver.programming)
  • Re: SSIS Connection
    ... I go into SSIS create a new project, right click in the bottom panel to ... 'New Connection') ... Does it occur for any OLEDB provider? ... >>I'm trying to create a new OLEDB connection in the RTM version of SQL 2005 ...
    (microsoft.public.sqlserver.dts)
  • SSIS 64bit to Oracle 10G
    ... Dose any one have a simple workaround to implement a connection from ... SQL 2005 SSIS 64 bit to Oracle 10 G ...
    (comp.databases.ms-sqlserver)
  • Re: Concurrent database access in SQL 2005 Mobile
    ... Please stick to having an "dummy" connection in Open State. ... SQL CE/Mobile has a background thread that flushes the changes ... they run for long hours and we have not seen memory leaks so far. ... then opens his work forms and it's in ...
    (microsoft.public.sqlserver.ce)
  • Re: Concurrent database access in SQL 2005 Mobile
    ... Please stick to having an "dummy" connection in Open State. ... So it is a kind of asynchronous commit which happens every 10 ... I am not sure of this claim as we have many applications built on SQL CE ... then opens his work forms and it's in ...
    (microsoft.public.sqlserver.ce)