SQL Server connection problems

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.

I had moved this machine from a physical to a virtual. I found the final solution here:

http://support.microsoft.com/kb/926642 (method 1 using the FQDN in the error message).

after reading this great post:
http://36chambers.wordpress.com/2010/04/08/how-to-set-up-aliases-for-nam...

Topics:

Comments

I did the exact same thing as Jacob did!  I had been looking and trying different things for over 2 hours.  I finally stumbled across this article and did Method 1... Just doing CNAME did not work!  You have to do FQDN.  Thanks!!

This is really good post and you have done really good work. Please update some more great post as soon. Your way of talking too good, Buy new rubber flooring from http://expressrubbermatting.co.uk/rubber-flooring.html

Very nice blog on this website! It is really difficult to find such a fantastic content with some useful information 
N10-006 test