I am getting this error message when I try to connect to SQL Server 2005 Express on another machine:
[error]
>sqlcmd -S MEDIA\SM700_DEMO
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.
[/error]
In the SQL Server Surface Area Configuration for the SM700_DEMO, I have enabled "Local and remote connections" and "Using TCP/IP Only".
I can successfully ping the SQL Server machine.
Suggestions?
Start Free Trial
