Sql 2005启动不了,报错如下时的解决办法!
解决办法:
开始->programs->MicroSoft SQL Server 2005->Configuration tools->SQL Server Configuration Manager
选择 SQL Server 2005 Network Configuartion-> Protocols for SQL ExpRESS 再 选择 TCP/IP 属性 ,选择IP Addresses
IP1 的 IP Address 请确认是 你服务器的 IP地址 , 如果服务器为本地的话。在网上邻居看一下IP 地址 填上。IP 2 为 127.0.0.1
---------------------------------------------------------------------------------------------------------------
报错如下:
2009-11-04 10:30:08.96 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2009-11-04 10:30:08.96 Server (c) 2005 Microsoft Corporation.
2009-11-04 10:30:08.96 Server All rights reserved.
2009-11-04 10:30:08.96 Server Server process ID is 1344.
2009-11-04 10:30:08.96 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2009-11-04 10:30:08.96 Server This instance of SQL Server last reported using a process ID of 1512 at 2009-11-4 10:28:23 (local) 2009-11-4 2:28:23 (UTC). This is an informational message only; no user action is required.
2009-11-04 10:30:08.96 Server Registry startup parameters:
2009-11-04 10:30:08.96 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2009-11-04 10:30:08.96 Server -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2009-11-04 10:30:08.96 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSS
相关文档:
C# SQL数据库操作通用类
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
namespace Framework.DataBase
{
///
/// 通用数据库类
///
public class DataBase
{
private string ConnStr = null;
public DataBase()
{
&nb ......
USE [master]
GO
/****** 对象: StoredProcedure [dbo].[sp_backupdatabase] 脚本日期: 07/15/2009 16:23:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[sp_backupdatabase]
@bak_path nvarchar(4000)='', ......
///<summary>
///备份数据库到本地磁盘
///</summary>
public bool BackUp(string BackUpFile)
{
try
&nbs ......