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!

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

SQL Error 7410

Status
Not open for further replies.
Apr 23, 2002
39
US
I'm kinda new to the SQL Server world, so if this is obvious, please forgive me.

I'm executing a job that has 15 steps, calling 15 different stored procedures. Each step errors with the following.

Executed as user: SQLAdmin. Remote access not allowed for Windows NT user activated by SETUSER. [SQLSTATE 42000] (Error 7410). The step failed.

I have ran the stored procedures in Query Analyzer and they complete fine. Is this a case of SQLAdmin logging in with NT authentication, or SQL authentication.

Thanks,
Don
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top