"Maria Bravo" <MariaBravo (AT) discussions (DOT) microsoft.com> wrote

SQLCMD.EXE is installed as part of the core SQL Server installation, but
it's not pathed by default.

You'll find it at C:\Program Files\Microsoft SQL Server\90\Tools\Binn.

You'll need to either change to that directory, or add the folder to your
path declaration.


--
Lawrence Garvin, M.S., MCITP(x2), MCTS(x5), MCP(x7), MCBMSP
Principal/CTO, Onsite Technology Solutions, Houston, Texas

Hey, this is just what I wanted to know. I am taking a course in Database
Management. We are learning SQL as a part of this course (or at least we
would like to learn SQL). The computers we have in the labs are running
Microsoft XP. I noticed on these computers that they have Microsoft SQL on
them. And I noticed using the Task Manager that SQL server is running
(sqlservr.exe, sqlbrowser.exe, and sqlwriter.exe are all listed under
processes) But I can't get this to run. I looked at the newsgroups and
discovered that there is this program called sqlcmd.exe. Why can't I use
these SQL servers to try to practice using SQL. I have downloaded MySQL on
my computer at home, and you can interact with it from the command prompt.
You can type things like "show tables" and you get a list of tables. I'd like
to be able to do that kind of thing here on these machines. When I try
running sqlcmd.exe, I get error messages:
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while
establi
shing a connection to the server. When connecting to SQL Server 2005, this
failu
re may be caused by the fact that under the default settings SQL Server does
not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

How do I get access to the SQL server so that I can try out SQL? I know
this is quite probably another episode in hopelessness, trying to get this to
work (I mean, why would a university allow their students who are taking a
course in Database Management, which specifically talks about SQL, actually
use the SQL on the computers they set up in the computer labs for us to use?).

"Lawrence Garvin" wrote:

The server instances are probably locked down (as they should be). Getting
access to them is a matter of having the right ports open and knowing the
right credentials or installing the right credentials on the server. See my
blog for handling connection issues.

--
__________________________________________________ ________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com http://betav.com/blog/billva
__________________________________________________ __________________________________________



"atelios" <atelios (AT) discussions (DOT) microsoft.com> wrote