If the SQL Statement works in the Query Analyzer but fails though a job this means there are different ports used when processing the job?
Date 12/1/2010 1:33:12 PM
Log Job History (Update Asset from SCCM)
Step ID 1
Job Name Update Asset from SCCM
Step Name Update Asset from SCCM
Sql Severity 16
Sql Message ID 7412
Operator Net sent
Retries Attempted 0
Executed as user: NT AUTHORITY\SYSTEM. The OLE DB provider "SQLNCLI10" for linked server "CONFIGMGRSRV" reported an error. Authentication failed. [SQLSTATE 42000] (Error 7399) Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for linked server "CONFIGMGRSRV". [SQLSTATE 42000] (Error 7303) OLE DB provider "SQLNCLI10" for linked server "CONFIGMGRSRV" returned message "Invalid authorization specification". [SQLSTATE 01000] (Error 7412). The step failed.
Which port(s) is(are) used in both cases?
System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support
View Complete Post