Incorrect syntax near 'S'

Question

I try to run the following command and I get the error in the title.

sqlcmd

-S tcp:XXXX.ctp.database.windows.net -U AAA@jXXXX -P YYYYYY -D ZZZZZZZZZ

Any help will be appreciated.

---

mysorian

Answer 1

The syntax seems to be incorrect. See this post for details http://msdn.microsoft.com/en-us/library/ee336280.aspx

The syntax should be: sqlcmd -U <ProvideLogin@Server> -P <ProvidePassword> -S <ProvideServerName> -d <ProvideDatabaseName>

http://syntaxhelp.com/SQLAzure/SQLCMD

---

Beyond Relational

Answer 2

Thanks
But, this is no good either. Now the error is at -U

---

mysorian

Answer 3

what is the value you are providing at -U? 

---

Beyond Relational

Answer 4

<ProvideLogin@Server>

However I have been able to connect using:
1. A UDL File
2. IIS7 Database Server

Some of these on my blog:
http://hodentek.blogspot.com

---

mysorian

Answer 5

Does running the SQLCMD in the command line makes a difference? I am running in the Query Window after choosing SQLCMD Mode.

---

mysorian

Answer 6

I am not sure if it makes a difference. I alway try the command line tool as a first option for troubleshooting. I would suggest you do that and see if you are able to connect.

---

Beyond Relational

Answer 7

Quite possibly SSMS has a bug!

---

mysorian

Answer 8

did you try this :
-S tcp:XXXX.ctp.database.windows.net -U AAA@jXXXX -P "YYYYYY" -d ZZZZZZZZZ

Answer 9

As I mentioned earlier SQLCMD works fine in the DOS window but in SSMS it returns the error in the original post. 

---

mysorian

Answer 10

I am not 100% clear what is working and what is failing.

The first post talks about an error in sqlcmd, but the very last post says the error happens in SSMS.

Could you please clarify where are you seeing the error?

Evan

Answer 11

You can run SQLCMD command line or in SSMS 

It fails in SSMS while it does not when run from command line.

---

mysorian