How to access remote sql server using sqlcmd?

Question

I am trying to access remote sql server on another machine using :

sqlcmd -S <ip address>

But it gives me error -

command not found

Am I doing this wrong? Sorry but I am very new to this technology, so please let me know how i can connect to server. I have also made a user 'xyz'. Should I have to download some client or something? One more important thing, there is nothing install on my machine for sql server.

Richard · Accepted Answer · 2014-07-03 07:27:05Z

1

You need to install the client tools, via the SQL Server installer, on any machine from which you connect to SQL Server.

For instance, I have the SQL Server 2012 client on this machine, with the following "shared components" of SQL Server installed:

Client Tools Connectivity
Client Tools Backward Compatibility
Documentation Components
Management Tools - Basic
  Management Tools - Complete

Clearly a minimal client wouldn't need all of these.

Also note there is a lot of cross version compatibility (eg. I can use the SQL Server 2012 tools to connect to SQL Server 2014, but clearly newer features may not be accessible).

answered Jul 3, 2014 at 7:27

Richard

110k21 gold badges214 silver badges279 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Aamir Over a year ago

thanks Richard for the valuable reply, but please tell me do i have to install it if I am accessing using jdbc not sqlcmd?

Richard Over a year ago

As far as I am aware: Yes. You still need the underlying "SQL Native Client" (which communicates to the server), JDBC and other DB access APIs are wrappers over the database specific components.

Aamir Over a year ago

can you suggest me any link for sql server 2008, so i can download the client and then give it a try?

Richard Over a year ago

@AamirSohail I always use the full Server install, no idea if there is a separate download: time to improve your search skills.

Aamir Over a year ago

i have downloaded the tsql package and now able to access remote sql server.

ceth · Accepted Answer · 2014-07-03 07:22:42Z

0

Did you install Sql Server Client Tools on "another machine" ?

answered Jul 3, 2014 at 7:22

ceth

45.5k63 gold badges191 silver badges300 bronze badges

4 Comments

Aamir Over a year ago

demas, no please tell me what client tool should I install? and one more thing, I am trying to access via jdbc code. So do i really need client tool?

ceth Over a year ago

As I see you use 'sqlcmd' program. It comes with MS SQL Client Tools (technet.microsoft.com/en-us/library/aa197918(v=SQL.80).aspx).

Aamir Over a year ago

for sqlcmd we need client ok, but what about jdbc? If i am trying to access using java code, do i need this tool?

ceth Over a year ago

As I know you need MS JDBC driver msdn.microsoft.com/en-us/sqlserver/aa937724.aspx

Collectives™ on Stack Overflow

How to access remote sql server using sqlcmd?

2 Answers 2

5 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related