SQL2008

I have a VM (virtual PC) running XP that I use to connect to my office.  The 
VM has been added to the domain and my user account is an admin on the local 
box.
I'm sa on the SQL Server.  From SSMS I can connect to SQL just fine, using 
trusted security.  From BI I can build packages and deploy them to SQL by 
"save a copy" and pointing it to SQL.  My credentials work just fine.  But 
from SSMS I can't connect to Integration Services.  I get the following 
error:

Cannot connect to MySqlServerName.
Additional information:
	Failed to retrieve data for this request. 
(Microsoft.SqlServer.Management.Sdk.Sfc)
		Connect to SSIS Service on machine "myserver" failed:
			Access is denied.

I've found several articles on the net, including one that mentions editing 
dcom's MsDtsServer's properties.  For one thing, neither my local box nor 
the SQL Server has MsDtsServer; they have MsDtsServer100.  The articles I've 
found don't say if I should edit the properties on the server or on my local 
box.  If this is my issue, do I need to edit the properties on the server, 
and is it the MsDtsServer100's properties?

Any ideas?  Thanks in advance.

Andre
 

Have you looked at the server logs? I suspect that you're not logging in 
with the ID you think you are, or the server isn't really setup for you the 
way you think it is.

"Andre" <no@spam.com> wrote in message 
news:eRNvpn3oKHA.5328@TK2MSFTNGP04.phx.gbl...
> SQL2008
>
> I have a VM (virtual PC) running XP that I use to connect to my office. 
> The VM has been added to the domain and my user account is an admin on the 
> local box.
> I'm sa on the SQL Server.  From SSMS I can connect to SQL just fine, using 
> trusted security.  From BI I can build packages and deploy them to SQL by 
> "save a copy" and pointing it to SQL.  My credentials work just fine.  But 
> from SSMS I can't connect to Integration Services.  I get the following 
> error:
>
> Cannot connect to MySqlServerName.
> Additional information:
> Failed to retrieve data for this request. 
> (Microsoft.SqlServer.Management.Sdk.Sfc)
> Connect to SSIS Service on machine "myserver" failed:
> Access is denied.
>
> I've found several articles on the net, including one that mentions 
> editing dcom's MsDtsServer's properties.  For one thing, neither my local 
> box nor the SQL Server has MsDtsServer; they have MsDtsServer100.  The 
> articles I've found don't say if I should edit the properties on the 
> server or on my local box.  If this is my issue, do I need to edit the 
> properties on the server, and is it the MsDtsServer100's properties?
>
> Any ideas?  Thanks in advance.
>
> Andre
>
> 

The SQL Logs don't have any information about this.  Also, all other users, 
with computers on the domain, are unable to connect to Integration Services 
from SSMS.   Please let me know if you have any other suggestions.

Andre 

Sorry about that. I do have one suggestion though:
microsoft.public.sqlserver.integrationsvcs



"Andre" <no@spam.com> wrote in message 
news:eSBsJP6oKHA.5776@TK2MSFTNGP04.phx.gbl...
> The SQL Logs don't have any information about this.  Also, all other 
> users, with computers on the domain, are unable to connect to Integration 
> Services from SSMS.   Please let me know if you have any other 
> suggestions.
>
> Andre 

OK, I'm an idiot. Didn't see the cross-post.

"Jay" <spam@nospam.org> wrote in message 
news:OSdZ1Q7oKHA.3792@TK2MSFTNGP06.phx.gbl...
> Sorry about that. I do have one suggestion though:
> microsoft.public.sqlserver.integrationsvcs
>
>
>
> "Andre" <no@spam.com> wrote in message 
> news:eSBsJP6oKHA.5776@TK2MSFTNGP04.phx.gbl...
>> The SQL Logs don't have any information about this.  Also, all other 
>> users, with computers on the domain, are unable to connect to Integration 
>> Services from SSMS.   Please let me know if you have any other 
>> suggestions.
>>
>> Andre
>
> 

lol - I wondered what you meant. :)  Thanks for the suggestions anyway.

"Jay" <spam@nospam.org> wrote in message 
news:#LyYN78oKHA.1552@TK2MSFTNGP05.phx.gbl...
> OK, I'm an idiot. Didn't see the cross-post.
 

Hi there

Is your instance named? If yes - probably this link will help you

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/23c264d2-39eb-4d9a-8dba-83b0a555249d/

Regards,
Gennadi



"Andre" wrote:

> SQL2008
> 
> I have a VM (virtual PC) running XP that I use to connect to my office.  The 
> VM has been added to the domain and my user account is an admin on the local 
> box.
> I'm sa on the SQL Server.  From SSMS I can connect to SQL just fine, using 
> trusted security.  From BI I can build packages and deploy them to SQL by 
> "save a copy" and pointing it to SQL.  My credentials work just fine.  But 
> from SSMS I can't connect to Integration Services.  I get the following 
> error:
> 
> Cannot connect to MySqlServerName.
> Additional information:
> 	Failed to retrieve data for this request. 
> (Microsoft.SqlServer.Management.Sdk.Sfc)
> 		Connect to SSIS Service on machine "myserver" failed:
> 			Access is denied.
> 
> I've found several articles on the net, including one that mentions editing 
> dcom's MsDtsServer's properties.  For one thing, neither my local box nor 
> the SQL Server has MsDtsServer; they have MsDtsServer100.  The articles I've 
> found don't say if I should edit the properties on the server or on my local 
> box.  If this is my issue, do I need to edit the properties on the server, 
> and is it the MsDtsServer100's properties?
> 
> Any ideas?  Thanks in advance.
> 
> Andre
>  
> 
> .
> 

PS Yes, I had similar problem and I could solve this by changing instance 
name in MsDtsSrvr.ini.xml 

"Gennadi Gretchkosiy" wrote:

> Hi there
> 
> Is your instance named? If yes - probably this link will help you
> 
> http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/23c264d2-39eb-4d9a-8dba-83b0a555249d/
> 
> Regards,
> Gennadi
> 
> 
> 
> "Andre" wrote:
> 
> > SQL2008
> > 
> > I have a VM (virtual PC) running XP that I use to connect to my office.  The 
> > VM has been added to the domain and my user account is an admin on the local 
> > box.
> > I'm sa on the SQL Server.  From SSMS I can connect to SQL just fine, using 
> > trusted security.  From BI I can build packages and deploy them to SQL by 
> > "save a copy" and pointing it to SQL.  My credentials work just fine.  But 
> > from SSMS I can't connect to Integration Services.  I get the following 
> > error:
> > 
> > Cannot connect to MySqlServerName.
> > Additional information:
> > 	Failed to retrieve data for this request. 
> > (Microsoft.SqlServer.Management.Sdk.Sfc)
> > 		Connect to SSIS Service on machine "myserver" failed:
> > 			Access is denied.
> > 
> > I've found several articles on the net, including one that mentions editing 
> > dcom's MsDtsServer's properties.  For one thing, neither my local box nor 
> > the SQL Server has MsDtsServer; they have MsDtsServer100.  The articles I've 
> > found don't say if I should edit the properties on the server or on my local 
> > box.  If this is my issue, do I need to edit the properties on the server, 
> > and is it the MsDtsServer100's properties?
> > 
> > Any ideas?  Thanks in advance.
> > 
> > Andre
> >  
> > 
> > .
> > 

Gennadi,

Thanks for the reply, unfortunately I'm still in the same situation.  I'm 
not running a named instance, but I went ahead and changed MsDtsSrvr.ini.xml 
to my machine name instead of ".".   I followed the rest of the article's 
suggestions but I still can't connect to SSIS from any remote PC.  Also as I 
mentioned, in Component Services I don't have a Com object named 
MsDtsServer; mine is named MsDtsServer100.  Is this my problem, or did MS 
just change the name of the object in SQL 2008?

Thanks, Andre 

I figured it out.  I added myself into the Administrator group on the SQL 
Server box and the error changed from "access denied" to "the rpc server is 
unavailable".  I then found this post that essentially told me I needed to 
add DTS into the firewall - SSIS was already allowed by the way.

http://www.kodyaz.com/articles/ssis-integration-services-remote-connection-rpc-server-unavailable.aspx

After I changed the firewall as described in this article I'm now able to 
connect.

I'm just curious though - I have several users I want to have access to SSIS 
from their workstation.  Is there a way to accomplish this w/o adding each 
one of them to the Administrator group on the SQL Server box?

Andre