I have been trying to pull from ms sql server, after entering the credentials (usdrname, password), i'm not able to look at the source table, could someone please guide me
What type of connection are you creating: ODBC or OLEDB? What happens when you test the connection? What do you see when you click on the 'select' button? If the owner of the tables in the DB is not the same as the user in your connection string, you may just need to change the owner in the 'Owner' drop down in the 'Create Select Statement' screen.
I attached a screen shot of the 'create select statement' screen. If you are able to connect, it might be that there is just a simple setup error. So, check to make sure: you are connected to the correct database; the Owner is set to the owner of the tables, and; at least the radial is checked for the Tables.
