I had to upgrade one of our production SQL Servers from 2005 to 2008.The new server was running Windows Server 2008.After finishing the migration I noticed the above error in the Event viewer of the new server.The SQL Server Agent archive had the below error.
"Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)"
After searching for a fix and messing around with the host file finally was able to fix this by modifying the registry.The steps is listed in this knowledgebase article.
No comments:
Post a Comment