Login failed. The login is from an untrusted domain and cannot be used with Windows authentication (Microsoft SQL Server, Error: 18452.
This error occurs for a BizTalk interface on my development VM and a bing search on the error yields many hits but none contain the word BizTalk. I am going write about it here because it took me a while to find a solution.
A BizTalk map runs a Database lookup and the data source is hard coded to BIZTALK_SQL. BIZTALK_SQL is an alias for a SQL database configured in the local host file on he BizTalk Server.
So far so good and this all works in the multi-computer production environment. I was late to the party and was trying to set all this up in my standalone development environment. My first issue was that the database lookup in the map did not find any values, although I did not get any error. Secondly, a SQL Server Management Studio session cannot connect to the BIZTALK_SQL alias and generates the error.
The solution was to disable the loopback check on the SQL server. As soon as I did this my map started to look up values correctly and SSMS could connect to BIZTALK_SQL. Great, now I get started removing all the custom databases from the BizTalk SQL instance.