In article <Xns9CFE1E2D6757Yazorman (AT) 127 (DOT) 0.0.1>, esquel (AT) sommarskog (DOT) se
says...

Sqlcmd: Error: Microsoft SQL Native Client : Unable to complete login
process due to delay in opening server connection.

If I run the same command on the server that is not accessible, using
either it's ip address...it's confusing. The command does not 'take';
instead of executing when I hit return, it shows

1>

as if I am supposed to enter another line?

Yes, the tcp protocol is enabled, and in the ip address tab, for IP2
(the one with the ip address of the server) it't both active and
enabled. The others like IP1, IP3, are not set to active. Port is 1433,
not dynamic.

mat (mat (AT) notarealdotcom (DOT) adr) writes:
OK. Try adding

-U someuser -P somepwd

If you now get "Login failed for login 'someuser'" connectivity is
working. The above could be a problem with using Windows authentication
in a workgroup.

That is the command prompt, at which you can enter SQL commands. That is,
you connected successfully.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

In article <Xns9CFE61DDD77A5Yazorman (AT) 127 (DOT) 0.0.1>, esquel (AT) sommarskog (DOT) se
says...
You're right, this is a workgroup not a domain. I normally use sql
server auth for that reason.

I do get get "Login failed for login 'someuser'" when I use a credential
local to the workstation; or a cred local to the server; or a known
valid sql server account on the server instance.

Example:
sqlcmd -S 12.12.12.150,1433 -U mywinlogin -P mypswd

Re the other issue, I know the command prompt. The question is why after
I type in a line like above and hit return, sometimes it executes the
command, and sometimes it offers a new line for more commands? I have
noticed that if I make a mistake with the command it's likely to offer a
new line; but often the command it ok and it still won't execute, adds
the line. Why does it do that and how would I force it to execute?

mat (mat (AT) notarealdotcom (DOT) adr) writes:
It always difficult to know such things on a distance without information.

Since I did not know what you use normally, I only wanted you to try
with a dummy user, to see whether the connectivity issue is sorted out.

So you are saying that now you are reaching an SQL Server instance,
but it does not like your username and password?

You need to enter "go" as a batch separator, to request the batch to
be sent to SQL Server.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx