When you don't check the option 'Trusted Connection' in the database dialog, AND don't provide any credentials (username, password), the operation 'Test SQL Connection' passes successfully.
Is this by design, and can you change that behaviour? It leads to a bit of confusion...