Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TJ
Posting Yak Master
201 Posts |
 Posted - 2002-01-04 : 13:00:51
|
| I have an sproc that runs 5 sprocs (1- Link server1 to server2, 2-Log onto server2, 3-run a query that inserts recs into a table on server2, and update recs in a table on server1, 4-log off of server2, 5- drop the link to server2) that runs when you execute it in query analyzer. We're trying to set up a job to run it from server1. I'm getting the following error message:Msg 7410, sev 16: Remote access not allowed for windows nts user activated by setuser. [sqlstate 42000]We're pretty sure it's a permissions problem, but can't seem to find what setting(s) need changed.Any help would be greatly appreciated.Thanks!Teresa |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-01-04 : 13:22:33
|
| Is your SQLAgent running in a domain account? (it should be -- otherwise you will not be able to access remote machines from any of your jobs) |
 |
|
|
TJ
Posting Yak Master
201 Posts |
Posted - 2002-01-04 : 13:56:55
|
quote:
Is your SQLAgent running in a domain account? (it should be -- otherwise you will not be able to access remote machines from any of your jobs)
Please bear with me, I'm a novice. Where do I look to find this out? Do I look on server1 or server2? Is there a correlation between them that I need to consider also? |
|
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-01-04 : 14:19:14
|
| Sounds like you are going to create and run this job on server1. Therefore, SQLAgent on server1 should run in a domain account. To find out:In Enterprise Manager, go to server1\Management. Right-click on SQL Server AgentOn the General Tab, make sure you have selected "This Account" option and entered valid account information in the appropriate textboxes. |
|
|
|
|
|
|
Scheduled Job Fails