SQLEXP 2008 Install

最新推荐文章于 2024-09-12 08:38:06 发布

原创最新推荐文章于 2024-09-12 08:38:06 发布 · 654 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sqlserver #sql server #properties #service #manager #network

DB - SQLServer 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了首次安装SQL Server 2008后遇到的客户端连接失败问题及其可能的原因与解决方案。主要包括未启用远程连接、TCP/IP未启用及防火墙设置不当等问题，并提供了具体的解决步骤。

The first time that SQLExp 2008 get installed, client connection (from either VS2010 or SQLServer Management Studio) always failed.

Possible Reason

1. "Allow Remote connection" not get ticked when SQLServer startsup.

Solution: in "Management Studio"=>Engine properties=>"Connections"=>"Allow Remote Connection to this server"

PS: by default, it's get ticked on.

2. "TCP/IP" not enabled for the "SQL Server".

Solution: By default, only "Shared Memory" is enabled. Go to "Configuration Manager" => "Network Configuration" => "Protocals for [InstanceName]" => Enable TCP/IP.

3. "Firewall". Firewall is open and the service gets blocked.

Solution: Fully open firewall or add Service into "unblock" list.

PS: SQLEXPR_x86_ENU (SQL Engine) vs SQLEXPRWT_x86_ENU (with management tools)

PS: How to see all the active ports? netstat -ano

PS: Different instances are listened on the same port which is hosted by "sqlservr.exe" Process, the port by default is 1433.

Reference:

1. http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

2. http://www.javaeye.com/wiki/topic/365162 如何查看本机某个端口被哪个进程 ...

[转]在windows命令行窗口下执行：>netstat -aon|findstr "8000"TCP 127.0.0.1:8000 0.0.0.0:0 LISTENING 4292看到了吗，端口被进程号(PID)为4292的进程占用，继续执行下面命令：>tasklist|findstr "4292" python.exe*32 然后打开任务管理器，杀掉他就好了