dbTalk Databases Forums  

Problem executing sproc on remote server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Problem executing sproc on remote server in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
dj
 
Posts: n/a

Default Problem executing sproc on remote server - 04-05-2006 , 10:16 AM






I need to run a sproc on SS2k server B as part of a scheduled job that runs
on SS2k
server B. The sproc and job were created by and owned by our designated
Service account, which is in the Admins group on both servers. Both W2k3
servers are running SS2k sp3a. Server B is not a linked server, nor do I
wish it become one.

I created a test job with only the sproc call and the job still fails with
this error:
"Executed as user: [domain\ServiceAccount]. Remote access not allowed for
Windows NT user activated by SETUSER. [SQLSTATE 42000] (Error 7410). The
step failed."

Running the same step in QA on Server A also causes an error:
"Server: Msg 18483, Level 14, State 1, Line 1
Could not connect to server 'SERVER1' because 'ServiceAccount' is not
defined as a remote login at the server."

I've looked at KB 811031 and other sites that describe the same problem, but
don't describe a solution (that applies here).

This would appear to be a security issue.
I've confirmed that ServiceAccount has the "Allow logon to terminal
server"box checked on the account properties dialog.

What am I missing?

Thanks.
dj



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.