SQL Server connection problemsSubmitted by jacob on Tue, 12/06/2011 - 5:09pm
I ran into a problem whereby my SQL Server jobs wouldn't run. I received this warning in the log:
The program sqlservr.exe, with the assigned process ID 4724, could not authenticate locally by using the target name MSSQLSvc/dev2.[DOMAIN]:[PORT]. The target name used is not valid. A target name should refer to one of the local computer names, for example, the DNS host name. Try a different target name.
I also saw this message:
The login is from an untrusted domain and cannot be used with Windows authentication.