• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1130
  • Last Modified:

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?

thanks
0
PMH4514
Asked:
PMH4514
  • 3
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you install the client tools of the sql 2005 installation.
0
 
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?
0
 
kamindaCommented:
Download and install SSMS Express or if you have the Installation DVD for Standard edition, install only Management tools.

Express is here to download

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
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?
0
 
kamindaCommented:
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
0
 
PMH4514Author Commented:
I see thank you!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now