Posted by Π on 11/18/06 17:09
On my local machine I have SQL Server developer edition and Express
edition installed. I wnet into the configuration manager and set
SQLExpress (and all other services) to run with LocalSystem authority.
> sqlcmd -L
Servers:
GUMP
GUMP\SQLEXPRESS
> sqlcmd -E
works just fine, but
> sqlcmd -E -S .\sqlexpress
gives me
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error getting enabled protocols list from
registry [xFFF
FFFFF].
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.
[Back to original message]
|