RE: Integration Services Login

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:

> 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.
> .
> --> Connect to SSIS Service on machine “ldqcedcmcache1” failed:
> Access is denied.
> .
>
> Thanks Again.
> --
> MVP888
>
>
> "Michael Cheng [MSFT]" wrote:
>
> > Hi,
> >
> > 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.
> >
> >
.

Relevant Pages

  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • It can be Done
    ... I just installed a 3 SQL Server 2005 instances on a 2 node Active/Passive cluster. ... IWiz will then offer you a choice of Group on where you can install teh Fail Over Clustered Instance of SQL. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)