I have a working vb.net(2019) / ASP.NET web app, and I'm trying to ADD a new SQL connection to a database that resides on a different SQL server.
The error I got initially when I tried, was: Login failed for user 'DOMAINNAME\IT-APP01$'. where IT-APP01$, is the web server.
I tried mucking with web.config settings, and tried creating a user account on the IIS server, and creating a matching one on (new)SQL server, but no help.(SQL is set to mixed mode)
Is this possible?
Working SQL version: 2012