Integration Services Login

How do I add myself into the Integration Services? so I can use SQL Server
Management Studio to log in Integration Services
First I tried loggin into the SQL Server 2005 itself using 'sa', add my NT
login as a login ie 'SomeGroup\SomeloginName', open the properties for the N
T
Login name & assign all roles including sysadmin to the name.
Then, go back to SQL Server Management Studio to connect to Integration
Services, it still say access deny
Thanks
--
MVP888Hi,
From your descriptions, I understood you are not able to connect SSIS with
the account even you have assigned SA privilege. If I have misunderstood
your concern, please feel free to point it out.
First of all, please use SQL Server Configuration Manager to make sure you
have started SQL Server Intergration Services.
Secondly, have you tried use both Windows Authentication and SQL
Authentication to login the SSIS?
Thirdly, is it possible for you to show us some screen shot?
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks Michael
1. SQL Server Integration Services started because I can login using the NT
account that was used to install the SQL Server but not other NT accounts.
2. I can not switch over to use the SQL Authentication option when I log
into Integration Services because it is grayed out. However, I do have the
SQL Authentication option when I log into the SQL Server Database itself.
(Why is that).
3.I have problem pasting the screen, but here is what on the error screen
when I try to log into SSIS
Cannot connect to ldqcedcmcache1.--> my machine name
Additional Information:
-->Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
--> Connect to SSIS Service on machine “ldqcedcmcache1” failed:
Access is denied.|||Hi,
[vbcol=seagreen]
the[vbcol=seagreen]
itself.[vbcol=seagreen]
Only Microsoft Windows Authentication is available for SSIS. Windows
Authentication mode allows a user to connect through a Windows user account.
For more detailed information, check the BOL topic below
Connect to Server (Integration Services)
http://msdn2.microsoft.com/en-us/library/ms183366(en-US,SQL.90).aspx
[vbcol=seagreen]
Since the SSIS will only allow Windows Authentication, please make sure
your Windows Account has sufficient privilege to SSIS.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
I've just fixed this problem myself. This probably isn't the proper fix,
but I found that adding the user to the local machine's (ie the SQL Server's
local group) administrators group gave me the rights to log on.
This is only a quick fix, but the issue must be that whatever user you want
to access integrations services must need certain levels of access to the
OS, most likely the ability to start and stop services.
Its a starting point anyway!
Regards
Brett
"MVP888" wrote:
[vbcol=seagreen]
> Thanks Michael
> 1. SQL Server Integration Services started because I can login using the N
T
> account that was used to install the SQL Server but not other NT accounts.
> 2. I can not switch over to use the SQL Authentication option when I log
> into Integration Services because it is grayed out. However, I do have th
e
> SQL Authentication option when I log into the SQL Server Database itself.
> (Why is that).
> 3.I have problem pasting the screen, but here is what on the error screen
> when I try to log into SSIS
> Cannot connect to ldqcedcmcache1.--> my machine name
> Additional Information:
> -->Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> --> Connect to SSIS Service on machine “ldqcedcmcache1” failed:
> Access is denied.
> .
> --> Connect to SSIS Service on machine “ldqcedcmcache1” fail
ed:
> Access is denied.
> .
> Thanks Again.
> --
> MVP888
>
> "Michael Cheng [MSFT]" wrote:
>|||I was pleased to find this subject posted on the technet board, but somewhat
dissappointed in the resolution. I too am getting the exact error as posted
by the originator. I just CANNOT get connected to an installation of
Integration Services other than the one running on my machine (Developer
Edition).
Where do I specify that a Domain Group has access to the Integration
Services? I can go to the Database Engine and give the group rights on the
server, but that only applies to the Database Engine, not the Integration
Services.
Do I need to do like Brett Hargreaves pointed out and add the Domain Group
to the local server's administrator group. I like to think there is a better
solution that that.
**********************************[vbcol
=seagreen]
> Since the SSIS will only allow Windows Authentication, please make sure
> your Windows Account has sufficient privilege to SSIS.[/vbcol]
***********************************
Where do I go to make that happen?
Thank you in advance.
ToddC
"Michael Cheng [MSFT]" wrote:

> Hi,
>
> the
> itself.
> Only Microsoft Windows Authentication is available for SSIS. Windows
> Authentication mode allows a user to connect through a Windows user accoun
t.
> For more detailed information, check the BOL topic below
> Connect to Server (Integration Services)
> http://msdn2.microsoft.com/en-us/library/ms183366(en-US,SQL.90).aspx
>
> Since the SSIS will only allow Windows Authentication, please make sure
> your Windows Account has sufficient privilege to SSIS.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>|||I've installed SQL2005 on my desktop, and have no problem connecting to "dat
abase engine" for databases, jobs etc, but when I try to connect to Integrat
ion Services from my desktop, I get the error:
Connect to SSIS Service on machine "SQL_TestServer" failed:
Access is denied.
I'm a member of sysadmin within SQL, as well as an administrator on the serv
er. I don't have any problem when I log on to the server directly via Remot
e Desktop and open IS. Am I missing something obvious ?