Post reply

Problem logging on to Integration Services

  • March 20, 2014 at 9:54 am

    #1698760

    For example, if your instance name is MSData:

    <TopLevelFolders>

    <Folder xsi:type="SqlServerFolder">

    <Name>MSDB</Name>

    <ServerName>\MsData</ServerName>

    </Folder>

    <Folder xsi:type="FileSystemFolder">

    <Name>File System</Name>

    <StorePath>..\Packages</StorePath>

    </Folder>

    </TopLevelFolders>

    </DtsServiceConfiguration>

  • March 21, 2014 at 12:51 am

    #1698953

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

  • March 21, 2014 at 2:09 am

    #1698963

    k.arkenau (3/21/2014)

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

    Under the servername parameter put the full instance name of the database engine you wish to use

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • March 21, 2014 at 2:21 am

    #1698966

    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>

    <ServerName>ELO-FROST-SQL1\SAPSQL</ServerName>

    </Folder>

    <Folder xsi:type="FileSystemFolder">

    <Name>File System</Name>

    <StorePath>..\Packages</StorePath>

    </Folder>

    </TopLevelFolders>

    </DtsServiceConfiguration>

  • March 21, 2014 at 5:01 am

    #1699025

    You just need two top level folders, one for each instance:

    <?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>

    <ServerName>.\InstanceName</ServerName>

    </Folder>

    <TopLevelFolders>

    <Folder xsi:type="SqlServerFolder">

    <Name>MSDB</Name>

    <ServerName>.\InstanceName</ServerName>

    </Folder>

    <Folder xsi:type="FileSystemFolder">

    <Name>File System</Name>

    <StorePath>..\Packages</StorePath>

    </Folder>

    </TopLevelFolders>

    </DtsServiceConfiguration>

  • March 27, 2014 at 4:06 am

    #1700603

    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">

    <Name>MSDB</Name>

    <ServerName>ELO-FROST-SQL1\SAPSQL</ServerName>

    </Folder>

    TopLevelFolders>

    <Folder xsi:type="SqlServerFolder">

    <Name>MSDB</Name>

    <ServerName>elo-frost-sql1</ServerName>

    </Folder>

    <Folder xsi:type="FileSystemFolder">

    <Name>File System</Name>

    <StorePath>..\Packages</StorePath>

    </Folder>

    </TopLevelFolders>

    </DtsServiceConfiguration>

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply