Viewing 8 posts - 1 through 8 (of 8 total)
I have taken the DB offline and back online with some success in this situation, just a thought.
March 21, 2014 at 8:18 am
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>
...
March 21, 2014 at 5:01 am
For example, if your instance name is MSData:
<TopLevelFolders>
<Folder xsi:type="SqlServerFolder">
<Name>MSDB</Name>
<ServerName>\MsData</ServerName>
...
March 20, 2014 at 9:54 am
No problem, just meant that if you are doing named instances, have to add them in the xml file.
March 20, 2014 at 9:39 am
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...
March 20, 2014 at 9:21 am
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
Edit <Install...
March 20, 2014 at 8:57 am
I found this link helpful for that same scenario, the permission changes you need are defined in the section Eliminating the "Access is Denied" Error:
March 20, 2014 at 8:19 am
Viewing 8 posts - 1 through 8 (of 8 total)