I am trying to connect to Database server using a sql login from the application but getting the following error:
Access to the remote server denied because no login mapping exits . Error attached along
The database server is configured to used Mixed mode authentication . It is further pulling data from 3 servers and we have link servers created on the central server .
Do I need to change the authentication mode to mixed mode for the other 3 sql servers too for the connection to be successful .
Regards.