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!!

Hhhmm this is something I need to work out how to solve too. Thanks for the links as they will help me out greatly. icariin

Provides multiple learning environment of International standard with holistic system of education at an affordable cost for the successful life of young generation.
Paramedical college in uttarakhand