SQLCMD connection to a db fails
Posted on 2006-11-30
When I attempt to connect to a DB through SQLCMD, while local to the SQL Server, the following command string produces the following error:
sqlcmd -l 90 -S SMSSERVER\SMS_C39 -U administrator -P password
PRODUCES THIS MESSAGE:
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
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.
What do you suggest I try differently?
Since the DBNAME and Instance Name are two different things, should I specifying an Instance Name instead? If so, where do I find that name? I only see DBs listed.