I want to use SQL server R2 2008(which in on another server) by installing its client. Is their any way to sort out my problem. Please help
You don't need Visual Studio to access MS SQL Server. If you're developing an application (as mentioning Visual Studio would imply), you need some library for your language of choice which would allow you to connect to the server.
What is the language you're using?
For example, for Python there's pymssql
There's also FreeTDS, which, as I understand, is a set of command-line tools and libraries to connect to MSSQL and Sybase servers.
At any rate, I think it would be very difficult to install Visual Studio in Ubuntu (well, apart from installing it inside a VirtualBox instance running Windows).