0

I am using SQL Server 2017 based on Windows server 2016. I am trying to connect my named instance, but I got the error message as below screenshot: Can not connect to SQL instance by SQLCMD

So I tried to reinstall ODBC Driver 13. But I got the error as follow: reinstall ODBC Driver 13

Even after I uninstalled ODBC Driver 17, I still got the same error message. Any thought?

Thanks in advanced!

asked Mar 28, 2019 at 16:08
3
  • 2
    Is the SQL Server Browser running on your server? Commented Mar 28, 2019 at 16:48
  • 1
    Does SSMS connect from the same machine? Are you on the same subnet? Maybe try with the IP address. Commented Mar 28, 2019 at 16:56
  • I disabled browser...and also tried IP address instead...I can connect by using -S (capital letter) instead of -s (lowercase) now. Thanks to Randolph and you guys help. Have a great one! Commented Mar 29, 2019 at 2:14

1 Answer 1

2

You must specify the server name with -S (capital letter) instead of -s (lowercase).

From the documentation:

 -s col_separator 
 -S [protocol:]server[instance_name][,port]
answered Mar 28, 2019 at 17:17
0

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.