I'm just using a standalone, not clustered, SQL 2014 instance. Mixed authentication. Other systems like Composer and View events are going to it, so its working.
yep, that's the code I used to create the database and user.
at first I was filling in all the networking fields, this time around I left the domain name and search path blank.
I'm using two DNS servers, separated by a comma. I'm sure this is configured correctly as I can log into the appliance as root and ping everything by hostname.
SQL 2014 threw a message saying the "grant ALL on Database" command is deprecated, so I'm looking into that.