How to access SQL Server without using SQL Server Management Studio

Question

I have two windows servers X and Y.

And I have SQL Server database on Y. X doesn't have SQL Server Management Studio on it. How can I access Database on Y from X without using (installing) SQL Server on X.

Thanks for your help

Answer 1

You can use a tool like SQuirrel SQL (free) or Aqua Data Studio.

Answer 2

One can use the sqlcmd utility. https://msdn.microsoft.com/en-us/library/ms180944.aspx

Answer 3

You need to install SQL Server Client tools on X. From the installation kit choose only Client conectivity tools. It is impossible to access a SQL server from a non SQL server without having at least the Client tools installed on the non-SQL server. You will be able to connect after installing either from SQL management studio or sqlcmd (cmd-line)