SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Not able to connect to the integration services


Not able to connect to the integration services

Author
Message
nareshmsbi13
nareshmsbi13
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 76
Not able to connect Integration Services in my server to local system(Development system) SQL Server Management Studio. I think this can be avoided by ensuring that users have the required DCOM permissions in the server,
Can u please tell me any one wt is the exact problem And why we cant connect to the integration server
And once we connect to the integration server the packeges should be created but the tabs will not be opend that mence the Control flow and the Data flow and Package explorer these tabs could not opend ,it will show the error like

Microsoft visual studio is unable to load this document
TO design integratoion services package in BI Devlopment studio ,Integration services has to be installd by one of these editions of sql server2008R2;standared enteprise developer or evalvation .To install integration services run sql server setup and select integration services,,,,,,this is the bug we are faceing in the creation of package creaion can u please resolve my problem as earliest and give the exact resoluction to this one
Paul Hernández
Paul Hernández
Old Hand
Old Hand (388 reputation)Old Hand (388 reputation)Old Hand (388 reputation)Old Hand (388 reputation)Old Hand (388 reputation)Old Hand (388 reputation)Old Hand (388 reputation)Old Hand (388 reputation)

Group: General Forum Members
Points: 388 Visits: 661
Hi,

I remembered a similar experience. You need to be sure that the Integration Services Service (I know it sounds redundant) is installed and enabled in the server. This is the first step. If this is the case you should be able to save the packages in the msdb from the BIDS.
Second issue, you can only connect to the Integration Server from the Management Studio with Windows Authentication.

I wrote a post with some useful T-SQL commands, maybe it can help you: Manage packages stored in the MSDB database with T-SQL
Regards,

Paul Hernández
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search