After installing Toad for SQL Server and choosing to migrate settings files from the previous install of Toad, and trying to connect to the database, the following errors occur:
"The path is not of a legal form"
and
"Could not find a part of the path 'C:\Program Files\Quest Software\Toad for SQL Server\Template\Scripts\InitialSqlServer.Sql'."
The connection seems to have been completed and work can be done in Toad.
If the option to migrate over settings from a previous install was accepted, and the settings file of the previous install is removed/moved, errors will occur.
Enter the location of the current InitialSqlServer.Sql file in the Tools | Options | Database | SQL Server | "Run Script on new connection:..." field. This should be in the current install directory under Template | Scripts.
Example:
older install: C:\Program Files\Quest Software\Toad for SQL Server\Template\Scripts\InitialSqlServer.Sql
new install: C:\Program Files\Quest Software\Toad for SQL Server 2\Template\Scripts\InitialSqlServer.Sql
Note: The elipse [...] to browse may produce a "Path not found error" so you may need to manually type in the location first.
Toad for SQL Server settings files are located by default in C:\Program Files\Quest Software\Toad for SQL Server\Template\Scripts. If an uninstall of the previous version of Toad is done after the install of the new Toad and the migration of the settings files, this path may be uninstalled. This produces an error because the Tools | Options | Database | SQL Server | "Run Script on new connection:..." field will have the path to the previous install's InitialSqlServer.Sql.
Toad will not offer the option to migrate settings files unless it finds a previous install of Toad still in the system. If settings are migrated, there are instances where the path to the old install is used.
