Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: Problem logging on to Integration Services

    Sorry for the delay, but I got busy with other things:

    It looks like this now:

    <?xml version="1.0" encoding="utf-8"?>

    <DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

    <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>

    <TopLevelFolders>

    <Folder xsi:type="SqlServerFolder">

    ...

  • RE: Problem logging on to Integration Services

    Ok, it looks like this now:

    <?xml version="1.0" encoding="utf-8"?>

    <DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

    <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>

    <TopLevelFolders>

    <Folder xsi:type="SqlServerFolder">

    <Name>MSDB</Name>

    ...

  • RE: Problem logging on to Integration Services

    Ok, there are two intances running on my system, one standard instance (MSSQL) and one named instance (SAPSQL). What to do then?

  • RE: Problem logging on to Integration Services

    I do named instances...just where to add then in this file?

  • RE: Problem logging on to Integration Services

    What to edit where? The xml file needs to be edited to reflect instance name(s):

    <?xml version="1.0" encoding="utf-8"?>

    <DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

    <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>

    <TopLevelFolders>

    <Folder xsi:type="SqlServerFolder">

    ...

  • RE: Problem logging on to Integration Services

    grantbruce (3/20/2014)


    This process worked for me:

    Verify account is member of Distributed COM Users

    @ Component services, My Computer, DCOM Config, Microsoft SQL Server Integration services 11.0, Properties, Security, add account

    OK

    Edit...

  • RE: Problem logging on to Integration Services

    That is what I already did...als told above.

  • RE: Problem logging on to Integration Services

    As the user did a lot of programming on the Database, he is sysadmin already.

  • RE: Problem logging on to Integration Services

    Hello,

    I just checked it once more:

    Yes, the User is member of the group Distributed COM-User and the group has the permissions you talked about.

    But if the user trys...

  • RE: Problem logging on to Integration Services

    Ok, I changed that and added the User to the DCOM User group.

    Nevertheless, the user still cannot logon to the information services.

    Any idea?

Viewing 10 posts - 1 through 10 (of 10 total)