Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Problem logging on to Integration Services Expand / Collapse
Author
Message
Posted Thursday, March 20, 2014 9:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 4:00 AM
Points: 11, Visits: 21
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

Post #1553071
Posted Thursday, March 20, 2014 9:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 21, 2014 8:16 AM
Points: 9, Visits: 10
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? 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">
<Name>MSDB</Name>
<ServerName>.</ServerName>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>..\Packages</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>

From: http://technet.microsoft.com/en-us/library/ms137789.aspx

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

Post #1553076
Posted Thursday, March 20, 2014 9:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 4:00 AM
Points: 11, Visits: 21

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">
<Name>MSDB</Name>
<ServerName>.</ServerName>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>..\Packages</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>



So you are saying I have to enter the configuration here? I am sorry, I am a little confused because originally you said something about "instances".
Post #1553085
Posted Thursday, March 20, 2014 9:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 21, 2014 8:16 AM
Points: 9, Visits: 10
No problem, just meant that if you are doing named instances, have to add them in the xml file.
Post #1553092
Posted Thursday, March 20, 2014 9:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 4:00 AM
Points: 11, Visits: 21
I do named instances...just where to add then in this file?
Post #1553095
Posted Thursday, March 20, 2014 9:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 21, 2014 8:16 AM
Points: 9, Visits: 10
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>
Post #1553101
Posted Friday, March 21, 2014 12:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 4:00 AM
Points: 11, Visits: 21
Ok, there are two intances running on my system, one standard instance (MSSQL) and one named instance (SAPSQL). What to do then?
Post #1553330
Posted Friday, March 21, 2014 2:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:54 PM
Points: 6,462, Visits: 13,909
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"
Post #1553344
Posted Friday, March 21, 2014 2:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 4:00 AM
Points: 11, Visits: 21
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>

Post #1553347
Posted Friday, March 21, 2014 5:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 21, 2014 8:16 AM
Points: 9, Visits: 10
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>
Post #1553416
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse