Using the Reverse Engineering tool I'm connecting to a SQL Server database. When building the connection, I use a SQL Server Native 10.0 provider and I also enter in a Username and Password for SQL Server Authentication. Within the Data Link Properties I click on Test connection and I receive a "Test connection succeeded" message. However when I click OK and then click on the Test connection within the Wizard, I get the following errors:
Connection failed because of the following error: "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication"
Followed by:
During connection to database this error occurs: "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication".
Current version of Toad Data Modeler doesn’t support the native provider.
When building the connection, choose the Microsoft OLE DB SQL Server provider option.