Can not connect to SSIS access denied

Question

I am facing an issue while connecting to SSIS thru Mangament studio. I'm able to connect to SQL engine, Analysis services but not able to connect to SSIS. I use windows authentication. I tried steps given at http://msdn.microsoft.com/en-us/library/aa337083(SQL.90).aspx but no help. On one of the forum I saw that one needs to restart the MSDTC service, Do I need to do that? bcoz my SQL admin said I need to justify it by assuring that it doesn't affect aything else. Moreover we didn't find way to restart the service, where I can do that? please help.

Thanks.

Answer 1

Have you got other instances of SQL Server?

You may need to specify a server name in MsDtsSrvr.ini.xml

(C:\Program Files\Microsoft SQL Server\90\DTS\Binn) or your equivalent local folder.

Answer 2

Are you getting an "Access Denied" error (since you are pointing to an MSDN-article about this) or something else?

Actually I am not sure if the "SQL Server Browser" (sqlbrowser.exe) does have anything to do with it (especially if you have multiple instances). Maybe restarting it would help (although admittedly this is just a guess).

Regards