Avatar of Butler Bros
Butler Bros
Flag for United States of America

asked on 

Connecting to two different SQL databsaes on 2 servers via ASP.NET

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
DatabasesMicrosoft SQL ServerASP.NETSQL

Avatar of undefined
Last Comment
Butler Bros

8/22/2022 - Mon