all groups > sql server dts > december 2005 >
You're in the

sql server dts

group:

Connect to SSIS via SQLManagement Studio


Connect to SSIS via SQLManagement Studio Jamie Schatte
12/31/2005 7:31:02 AM
sql server dts: I am trying to connect to Integration Services from my workstation via SQL
Server Management Studio. The SSIS service is installed and running on the
server. However, when I try to connect, I get the error:

"Connect to SSIS service on machine "SQLPROD01" failed:
Access is denied."

Not sure what's happening here--the connection dialog doesn't allow a user
name or password to be entered. Thanks in advance for any help!
--
Jamie Schatte
RE: Connect to SSIS via SQLManagement Studio Jamie Schatte
1/2/2006 2:14:02 PM
Sorry--responding to my own post! However, it seems a few others also having
this problem. Seems to be related to an inability of my workstation PC to
connect to the server via port 135. In our company, this port is blocked
internally. I am working with our IT team to resolve this issue, but
basically if you cant get to the server via port 135, you get the "Access is
AddThis Social Bookmark Button