最近我安装了SQL server 2008 R2,可是无法启动SQL server 服务器,在网上也查找了解决办法,但还是没有解决。以前都没有这种情况。现在还要做毕业设计,刚做一半。求大神们帮忙。
错误报告日志如下:
2014-04-10 09:57:08.12 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
2014-04-10 09:57:08.12 Server (c) Microsoft Corporation.
2014-04-10 09:57:08.12 Server All rights reserved.
2014-04-10 09:57:08.12 Server Server process ID is 6296.
2014-04-10 09:57:08.12 Server System Manufacturer: 'ASUSTeK Computer Inc.', System Model: 'K42De'.
2014-04-10 09:57:08.12 Server Authentication mode is MIXED.
2014-04-10 09:57:08.12 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2014-04-10 09:57:08.12 Server This instance of SQL Server last reported using a process ID of 3768 at 2014/4/10 9:20:27 (local) 2014/4/10 1:20:27 (UTC). This is an informational message only; no user action is required.
2014-04-10 09:57:08.13 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2014-04-10 09:57:08.19 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2014-04-10 09:57:08.19 服务器 Detected 2 CPUs. This is an informational message; no user action is required.
2014-04-10 09:57:08.26 服务器 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.
2014-04-10 09:57:08.29 服务器 Node configuration: node 0: CPU mask: 0x0000000000000003:0 Active CPU mask: 0x0000000000000003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2014-04-10 09:57:08.33 spid6s Starting up database 'master'.
2014-04-10 09:57:08.45 spid6s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2014-04-10 09:57:08.47 spid6s SQL Trace ID 1 was started by login "sa".
2014-04-10 09:57:08.47 spid6s Starting up database 'mssqlsystemresource'.
2014-04-10 09:57:08.50 spid6s The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
2014-04-10 09:57:08.64 spid10s Starting up database 'model'.
2014-04-10 09:57:08.65 spid6s Server name is 'PC201402171423'. This is an informational message only. No user action is required.
2014-04-10 09:57:08.83 服务器 A self-generated certificate was successfully loaded for encryption.
2014-04-10 09:57:08.83 服务器 Server is listening on [ 'any' <ipv6> 1433].
2014-04-10 09:57:08.84 服务器 错误: 26023,严重性: 16,状态: 1。
2014-04-10 09:57:08.84 服务器 Server TCP provider failed to listen on [ 'any' <ipv4> 1433]. Tcp port is already in use.