sqmcmd running standalone?

I have two PC's on the same intranet, physically on top of each other actually, one is running SQL Server 2005 Standard edition, the other has no database server. Both are Windows 2003 Server.

I wonder if it's possible to put a "standalone" copy of SQLCMD on the application server such that it can execute scripts against the DB server on the other box?

Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
you install the client tools of the sql 2005 installation.
PMH4514Author Commented:
ahh that is all? There is no conflict then? I guess I wasn't aware you could install client tools only.

I wonder - can I install the SQL Server 2005 Express Edition client tools instead of the standard edition?
kamindaConnect With a Mentor Commented:
Download and install SSMS Express or if you have the Installation DVD for Standard edition, install only Management tools.

Express is here to download

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

PMH4514Author Commented:
err, wait I think I mis-read.

I believe the client tools are installed on the SQL 2005 Installation.

How does that give me the ability to run SQLCMD from the command line prompt of the box that does not have SQL Server installed on it?

Or did you mean to say I should install the client tools on the NON database server?
You can only run sqlcmd from a computer that has the SQL Server client tools installed. So install client tools on the other computer then you can use SQLCMD
PMH4514Author Commented:
I see thank you!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.