Viewing 10 posts - 1 through 10 (of 10 total)
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">
...
March 27, 2014 at 4:06 am
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>
...
March 21, 2014 at 2:21 am
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 12:51 am
I do named instances...just where to add then in this file?
March 20, 2014 at 9:42 am
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">
...
March 20, 2014 at 9:30 am
grantbruce (3/20/2014)
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...
March 20, 2014 at 9:13 am
That is what I already did...als told above.
March 20, 2014 at 8:28 am
As the user did a lot of programming on the Database, he is sysadmin already.
March 20, 2014 at 8:28 am
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...
March 19, 2014 at 2:06 am
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?
March 19, 2014 at 1:15 am
Viewing 10 posts - 1 through 10 (of 10 total)