After connecting to a SQL Server database, using SQL Connect, there are no tables listed in the SQL dialog box and the Connect button is disabled.
In most cases when you connect to a SQL Server database, using SQL Connect, you will be prompted for a username and password for access to the database. The username and password are then passed to the SQL Server database to verify your account. The database is then queried based on the user logged in as the owner of tables. If the user does not own any tables, ArcView will not list any tables in the SQL dialog.
You may want to contact your database administrator to find the owner names of the tables you are interested in.