I also tried to use Windows Authentication to reverse engineer a database, I left the connection methos set to Native Connection and left the User name and password empty. I received an error message back station that the “sa” password was invalid.
When I switched to “Connect via ADO”, it asked me to enter the connection string. I entered both:
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
Replacing MyServerAddress and MyDataBase with real values, I also tried using the IP address for myServerAddress - nothing worked.
The only way I am able to connect is by using SQL Server Authentication - I have to create the account, reverse the database, then drop the account (we have strict security policies).
It would be much easier to select the connection method to use (Windows or SQL Server) and when using the ADO driver, prompt for the SQL Server and Database to connect to and TDM construct the connection string.