I'm going to have to build an app in PHP which does this, but before I do that I'd like to connect to it with a client tool just to see how things are structured and such. I'm afraid I don't know much ...

To run your SQL Pass-Through views for the MS SQL Server, you are encouraged, but not required, to create a data source name. You can use the ODBC administrator to create it. Refer to Data Source ...