August 24, 2005 at 12:00 pm
I use EM to run many jobs, some of them involves access disk files on the SQL server machine or on another SQL Server, or central storage. If the user registered in EM is sa, what Windows user account it is mapped to when access local or remote files.
I failed many jobs in the past due to OS access privileges. I guess many are due to the sa user. However, if I use OS authentication to register in EM, I run into problem using linked server in procedures.
Any good way to aloow both ?
Thanks
August 24, 2005 at 5:35 pm
Windows account for sa is the sql server startup account.
For scheduled jobs, it is sqlserveragent startup account.
August 25, 2005 at 12:42 am
in addition to wz700's reply :
regarding the linked server : it depends on how the linked server is defined at your local server. Check the security settings with EM\Secutity\Linkedservers right-click the linked server check properties and go to the security tab.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 25, 2005 at 1:41 pm
Thanks. Thal all help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply