Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Integration Services connection issues

Author  Topic 

jfloan
Starting Member

4 Posts

Posted - 2008-10-10 : 15:00:39
Hello,



I am in a SQL Server 2005 database called "jbbidev". I have rights to most of the databases on this server. I log in using my Windows authentication. Then in the Registered Servers panel, I select the Integration Services icon. I right click Integration Services --> New --> Server Registration. I type in the server name, and click "Test" and get an error:




I am clueless as to why I am unable to connect to this service. The DBA is under the impression that I have access to this and is fresh out of ideas. We get this exact same error from another user on another machine as well. Any advice would be greatly appreciated. Thanks in advance!

parag.sv
Starting Member

11 Posts

Posted - 2008-10-11 : 18:46:20
This could be helpful for you..just check it out

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=289425&SiteID=1

Thanks
para
Go to Top of Page

parag.sv
Starting Member

11 Posts

Posted - 2008-10-11 : 18:51:02
or may be this can help

http://www.etiennek.com/2008/01/16/connect-to-ssis-service-on-machine-sqlserver01-failed/

Thanks,
Para
Go to Top of Page

Aryengar
Starting Member

1 Post

Posted - 2008-10-14 : 08:28:56
Here's a workaround:
http://support.microsoft.com/kb/940232
Go to Top of Page
   

- Advertisement -