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

I did precisely the same as Jacob did! I had been looking and attempting changed things for more than 2 hours. I at long last discovered this article and did Method.
For More See Our Link: EssayLibrary.co.uk

That's a great info about SQL Server. its very useful for programming students, Well i am assignment expertand that post given me very help for my new assignment.

I did determinedly the similar as did! I had been Masterpaperwriters.com look and endeavoring distorted belongings for over hours. I finally establish this editorial and did Method.

That is an incredible information about SQL Server. Write my essay paper .It's extremely valuable for programming understudies, well I am and that post given me exceptionally help for my new task.

I did correctly the same as Jacob did! Can someone write my paper .I had been looking and endeavoring changed things for over 2 hours. I finally found this article and did Method.

That is an incredible data about SQL Server. its extremely valuable for programming understudies, Well i am and that post given me exceptionally help for my new task. http://www.researchpapergurus.com/

The program sqlservr.exe, with the allocated procedure ID 4724, couldn't validate locally by utilizing the objective name MSSQLSvc/dev2.[DOMAIN]:[PORT]. The objective name utilized is not substantial. An objective name ought to allude to one of the neighborhood PC names, for instance, the DNS have name. Attempt an alternate target name. http://www.groovyessays.com/university-essays/

Follow these steps to enable TCP/IP:
Start SQL Server Configuration Manager.
Expand SQL Server Network Configuration.
Select Protocols for MSSQLSERVER.
Right-click TCP/IP, and select Enable.
Select SQL Server Services.
Right-click SQL Server (MSSQLSERVER), and select Restart. http://www.proessay.co.uk/

I essentially need to offer fundamental a commitment of gratefulness is altogether for this awesome post of Someone do my assignment for me, quality article and will look an essential measure of your specific mesmerizing substance. Terrific sharing in this web at http://www.assignmentland.com/write-my-assignment

I essentially need to offer huge appreciative for this astonishing post of Fast Essay Writing. You made you appear and by no discussion about. Thank for sharing this educational information at this website at http://www.ontimepaper.com/essay

The writer has made a magnificent article of Please write my assignment for me. You made you show up and no discussion about. Probably this particular truth that you can not battle with the fact of the matter is not expensive, everything has its unprecedented case. A devotion of gratefulness is altogether for this data in this web at http://www.assignmentkeen.com/write-my-assignment