I have Toad for SQL Server 220.127.116.112 and I try to connect to a local .mdb file with Windows Authentication. I get login failed. I use the database programatically, and my connection string has Integrated Security=True ,and the program uses it just fine without password requirements. I would expect Toad to be able to connect with Windows Authentication.
I also tried connecting with SQL Server Authentication and sa for login and I get The user is not associated with a trusted SQL Server connection.
What can I do to use Toad for my SQL Server Express ?