October 26, 2011 at 12:48 pm
I'm trying to follow the following directions as a workaround for a problem I've been experiencing, but I'm not exactly sure what the account they're referring to in step 5c. Is it "NT AUTHORITY\NETWORKSERVICE" or "sa" or ?? In either case, it can't seem to find the account when I try to assign permissions to a folder.
1. Control Panel-> Administrative Tools-> Component Services
2. Drill to Component Services-> Computers
a. Right-click My Computer-> Properties
3. MSDTC tab -> Security Configuration button (screenshot below)
a. Network DTC Access – checked.
b. Allow Inbound / Outbound – checked.
c. No Authentication Required – This simulates the windows 2000 security settings.
d. Enable XA transactions – the type of transaction implemented by OraOLEDB provider.
4. Drill to Component Services-> Computers-> My Computer-> DCOM Config
a. Right-click MSDAINITALIZE-> Properties
5. Security tab (screenshot below)
a. Access Permissions -> Customize.
b. Press “Access Permissions” Edit button.
c. Give the SQL Server Service account “Local Access” permission.
d. Repeat for “Launch and Activation”.
Any ideas?
Thanks,
Mike
Mike Scalise, PMP
https://www.michaelscalise.com
October 26, 2011 at 12:53 pm
its the account that the SQL services are running under.
this could be local system, network service or a domain user set up for the purpose.
Check in SQL configuration manager to see which it is.
---------------------------------------------------------------------
October 26, 2011 at 1:10 pm
That's what I thought. I'm running under "NT AUTHORITY\NETWORKSERVICE" but apparently you can't add permissions to folders in windows using that verbiage. I think it uses "Network Service"
Thanks,
Mike
Mike Scalise, PMP
https://www.michaelscalise.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply