Every time I tried to connect to a SQL Server database, I get the following error:
"C:\Documents and Settings\<user>\Application Data\Quest Software\Toad for Data Analysts <version>\Templates\Scripts\InitialSqlServer.Sql was not found"
The path to InitialSqlServer.Sql is wrong so TDA cannot see it.
1. Go to Tools | Options
2. Expand 'Database' and go to 'SQL Server'
3. On the right-had side, under "Run script on new connection" change the path to reflect where InitialSqlServer.Sql is located at.
Note: It is likely your existing path is pointing to the wrong version folder (e.g. Toad for Data Analysts 2.6 instead of Toad for Data Analysts 2.7). So pointing the path to the correct version folder would suffice.
4. Press OK