sql server 2005 express 无法启动！！！
我的sql server 是VS2008自带的express版本，最近我改了主机IP之后发觉无法启动，我猜测和IP地址有关
于是就在管理器中对TCP/IP配置尝试进行修改，可是我发现无论怎么修改也无法使得TCP/IP生效，而且TCP/IP的属性中协议页面中仅仅只有一项保持活动状态，其它选项都没有。

请教大家！


log 错误如下：
2009-11-19 17:46:13.86 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) 
 Feb 9 2007 22:47:07 
 Copyright (c) 1988-2005 Microsoft Corporation
 Express Edition on Windows NT 6.0 (Build 6001: Service Pack 1)

2009-11-19 17:46:13.88 Server (c) 2005 Microsoft Corporation.
2009-11-19 17:46:13.88 Server All rights reserved.
2009-11-19 17:46:13.88 Server Server process ID is 6016.
2009-11-19 17:46:13.88 Server Authentication mode is WINDOWS-ONLY.
2009-11-19 17:46:13.88 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2009-11-19 17:46:13.88 Server This instance of SQL Server last reported using a process ID of 5060 at 2009/11/19 17:41:19 (local) 2009/11/19 9:41:19 (UTC). This is an informational message only; no user action is required.
2009-11-19 17:46:13.88 Server Registry startup parameters:
2009-11-19 17:46:13.88 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2009-11-19 17:46:13.88 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2009-11-19 17:46:13.88 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2009-11-19 17:46:13.91 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2009-11-19 17:46:13.91 服务器 Detected 2 CPUs. This is an informational message; no user action is required.
2009-11-19 17:46:14.14 服务器 Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2009-11-19 17:46:14.28 服务器 Database mirroring has been enabled on this instance of SQL Server.
2009-11-19 17:46:14.28 spid5s Starting up database 'master'.
2009-11-19 17:46:14.52 spid5s SQL Trace ID 1 was started by login "sa".
2009-11-19 17:46:14.56 spid5s Starting up database 'mssqlsystemresource'.
2009-11-19 17:46:14.59 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2009-11-19 17:46:14.75 spid8s Starting up database 'model'.
2009-11-19 17:46:14.75 服务器 错误: 17182，严重性: 16，状态: 1。
2009-11-19 17:46:14.75 服务器 TDSSNIClient initialization failed with error 0x2, status code 0xd.
2009-11-19 17:46:14.75 spid5s Server name is 'WIN-41ZYFOJP9R6\SQLEXPRESS'. This is an informational message only. No user action is required.
2009-11-19 17:46:14.75 服务器 错误: 17182，严重性: 16，状态: 1。
2009-11-19 17:46:14.75 服务器 TDSSNIClient initialization failed with error 0x2, status code 0x1.
2009-11-19 17:46:14.75 服务器 错误: 17826，严重性: 18，状态: 3。
2009-11-19 17:46:14.75 服务器 Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2009-11-19 17:46:14.75 服务器 错误: 17120，严重性: 16，状态: 1。
2009-11-19 17:46:14.75 服务器 SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.



------解决方案--------------------
楼主不仅仅是改了IP这么简单，还改了机器名。
建议安装开发版，功能较全面。