Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running a Task under a different user id

Status
Not open for further replies.
jimmYLepp

jimmYLepp

Programmer
Jan 22, 2002
39
0
0
US
For a specific job that logs onto another server I get the error

Executed as user: USTRESACC\cccsqladmin. Login failed for user 'USTRESACC\cccsqladmin'. [SQLSTATE 28000] (Error 18456). The step failed.


which means I need to change who the SQL Agent is running under, but I can't, seems that this server is logging onto other SQL Servers and needs this login for that. Does anybody know a way to run the single job as a different user?


jimmY
 
Status
Not open for further replies.

Similar threads

baran121
  • Locked
  • Question
take a database from system databse place
Replies
2
Views
80
iambob
iambob
TheBugSlayer
  • Locked
  • Question
High Availability - insert fails on primary replica but runs on secondary after failover.
Replies
0
Views
79
TheBugSlayer
TheBugSlayer
RRinTetons
  • Locked
  • Question
Logging into a database using SSMS from non-domain machine
Replies
1
Views
103
fredericofonseca
fredericofonseca
tekpr00
  • Locked
  • Question
Hello I am new to a new organizatio
Replies
1
Views
50
johnherman
johnherman
tekpr00
  • Locked
  • Question
Backups in a multiserver environment while using Central Management Server and Server Groups
Replies
0
Views
58
tekpr00
tekpr00

Part and Inventory Search

Sponsor

Back
Top