I am not a SQL Server admin. I have tried to google this but can't seem to use the right words to get the right info and they all talk about remote connections to a SQL Server in terms of admin and remote access.
I have a database on one domain, that needs to accept connections and queries etc... from web code (page) I am hosting on another domain. I am using Windows 2012 servers on AWS in the case of both domains, and I have port 1433 opened on the domain server with the database, but open only to the ip address of this other domain. The SQL Server is using the default windows based auth.
Can someone tell me where to find a guide to set up the SQL Server to accept these external requests with a proper user name and password ?