I have an SQL Server running on an AWS RDS Instance. I can connect fine using SQL SMgr on my local machine but I get an error message from an application I run on my local machine which needs to publish data to the DB. I've read some stuff about VPCs and security groups but wanted to know if this is actually possible.
The error message reads:
COM Error
Code = 80004005
Code meaning = unspecified error
Source = Microsoft OLE DB Provider for SQL Server
Description = Login failed. The login is from an untrusted domain and cannot be used with windows authentication.