Home Forums SQL Server 2012 SQL 2012 - General Problem logging on to Integration Services RE: Problem logging on to Integration Services

  • March 20, 2014 at 9:13 am

    #1698732

    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 <Install path; mine is D>:\Program Files\Microsoft SQL Server\110\DTS\Binn\MsDtsSrvr.ini.xml, add new instance(s)

    What to edit where?

    Regedit HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\SSIS\ServiceConfigFile

    <Installpath: mine is D>:\Program Files\Microsoft SQL Server\110\DTS\Binn\ MsDtsSrvr.ini.xml

    OK

    Grant account db_ssisadmin permissions in MSDB

    Already granted.

    Restart IS