Using TOAD with Vista 4.3

[Product_Support]

Issue

Using TOAD with Vista 4.3

Environment

• Vista 4.3
• TOAD

Cause

The release notice for Vista 4.3 recommended the use of TOAD which is a free program that allows users to view and query SQL databases. This can be a very powerful tool to assist in database verification, exploration of the database for creating Crystal Reports, and running scripts.

Resolution

Warning: Care should be taken before making any changes to the SQL database since damage could break Vista

To setup TOAD to work with the Vista database:

1. Run Vista Server Setup and check the "SQL Server" tab and write down what is filled into the Instance and Database fields.
2. Run TOAD_SS.exe.
3. At the Server Login screen select "Add".
4. Give your connection a name.
5. Select "Use Connection String" and click "Build".
6. Select "Microsoft OLE DB for SQL Server".
7. Click "Next".
8. In section "1" use the dropdown menu to select the Instance name found in Vista Server Setup. Typically the PC name or PC Name\TACVISTA.
9. Select "Use Windows NT Integrated Security".
10. In section "3" verify that "Select the database on the server" is selected and with the drop down menu choose the database name found in Vista Server Setup. Typically "taclogdata".
11. Click "Test Connection" to verify it is working and click "Ok".
12. Click "Ok" in the Data Link Properties window.
13. Click "Ok" in the Add Registration window.
14. Select the line your server was added to and click "Connect".

You should now be connected to the server and you can use the Data Browser window to view the tables, views, procedures, and users of the database among other things. The SQL Editor window will allow you to run queries as well as other administrative tasks. Remember that all changes should be carefully considered before made to avoid breaking the database.