Thank you for your prompt response Jeremy. I am looking for an inexpensive way to access the data from SQL Server Database. Do I have to purchase Client versions and then install (SSMS, BIDS, SSIS, VS, drivers, etc.)?
My apologies if this seems very basic, but I am new to your forum and have not actually used SQL Server in the past. Alternatively, is it possible to use the client tools you mentioned without installing the client or must the client be installed too. Alternatively can Microsoft Access to connect to the SQL Server (cost is a driver).