Question About Instance Name On Sqlserver 2005 And Sqlcmd

Hello,

I am using sqlcmd for SQL server 2005. I install sql2005 with default instance name. It should be MSSQLSERVER.

However, when using sqlcmd, like sqlcmd -S (local)MSSQLSERVER, it always aborts and suggests a wrong connection string.

I try to find any instance name under servername, but I can't find a command argument with sqlcmd.

So how can I solve the connection string problem? I can connect to the server using "sqlcmd -s (local)" though.

Or, how can I find the instance name of the server?  Or maybe any gramma error using sqlcmd to access instance name?

 

Thanks for your any inputs.

 

Regards,

Aaron