I am using Access as a front end to SQL Server 2014 backend database using DSN-less connections to tables and for pass-thru queries. All works fine. I have recently created a second database within the same instance of SQL Server, and believe I have set log in credentials the same for both, but am unable to programatically set up the DSN-less connections to the second database (Tables and views of both are the same). I get the Microsoft Server login error saying 'Connection failed". I am using Windows authentication. Some pointers as to how to trouble shoot this problem would be appreciated.
Software/Hardware used: MS Access, SQLerver 2014, Visual Basic