SQLEXP 2008 Install

最新推荐文章于 2024-03-09 19:13:58 发布

Insighteer

最新推荐文章于 2024-03-09 19:13:58 发布

阅读量612

点赞数

分类专栏： DB - SQLServer 文章标签： sqlserver sql server properties service manager network

本文链接：https://blog.csdn.net/Insighteer/article/details/6213039

版权

DB - SQLServer 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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 然后打开任务管理器，杀掉他就好了