sql-server - 无法打开与 sql server 的连接

Question

我正在命令行中运行它:

sqlcmd -s .\SQLexpress

我得到的输出是:

HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2]. Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or in stance-specific error has occurred while establishing a connection to SQL Server . Server is not found or not accessible. Check if instance name is correct and i f SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.. Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

当我运行这个时:

c:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe" -sSQLEXPRESS

我得到:服务器错误 17058 严重性 16，状态 1，无法打开错误日志文件

但是这有效:

osql -S .\SQLExpress -E

Answer 1

转到“开始”->“运行”，键入“C:\Windows\System32\mmc.exe/32 "C:\Windows\system32\SQLServerManager.msc”，然后转到“SQL Native Client 配置”、“客户端协议(protocol)”并检查共享内存、tcp/ip 和命名管道已启用。