PhoenixDon
MIS
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
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