none
SQL Server 2008 Express 無法啟動. RRS feed

  • 問題

  • 不知是不是之前有其他 SQL版本所致.

    有移除 SQL2005及於 新增/移除程式中, 將所有的 sql全移除後.

    重新安裝 SQL 2008 express, 但, SP1失敗.

    迄今仍無法啟動成功.


    • 已編輯 jenwang 2014年10月31日 上午 09:30
    2014年10月31日 上午 09:30

解答

所有回覆

  • Change service account to local system then try again. By the way, can you post most recent sql server error log?
    2014年10月31日 下午 01:05
  • 找到國外論壇上有一篇討論跟您的錯誤訊息類似,似乎是model db有問題,不曉得您的狀況是否相同,不妨參考看看。

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a7466c1c-e113-43ef-b0af-d841644a9d48/the-sql-server-mssqlserver-service-terminated-with-servicespecific-error-1814-0x716?forum=sqldatabaseengine


    以上說明若有錯誤請指教,謝謝。

    | 台灣 SQL PASS 社群 | SQL PASS Taiwan

    | 歡迎參觀我的BLOG - 積沙成塔

    2014年11月3日 上午 12:50
    版主
  • C槽還有36.1G
    2014年11月3日 上午 01:31
  • C槽約有36G, D槽有13G

    D槽有約14G

    2014年11月3日 上午 01:32
  • 謝謝您.

    SQL EXPRESS ERROR LOG:

    2014-10-31 17:07:10.56 Server      Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)
     Mar 29 2009 10:27:29
     Copyright (c) 1988-2008 Microsoft Corporation
     Express Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

    2014-10-31 17:07:10.66 Server      (c) 2005 Microsoft Corporation.
    2014-10-31 17:07:10.66 Server      All rights reserved.
    2014-10-31 17:07:10.66 Server      Server process ID is 4716.
    2014-10-31 17:07:10.66 Server      Authentication mode is WINDOWS-ONLY.
    2014-10-31 17:07:10.66 Server      Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
    2014-10-31 17:07:10.70 Server      This instance of SQL Server last reported using a process ID of 3120 at 2014/10/31 上午 08:47:49 (local) 2014/10/31 上午 12:47:49 (UTC). This is an informational message only; no user action is required.
    2014-10-31 17:07:10.73 Server      Registry startup parameters:
      -d c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\master.mdf
      -e c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG
      -l c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
    2014-10-31 17:07:10.88 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2014-10-31 17:07:10.88 Server      Detected 2 CPUs. This is an informational message; no user action is required.
    2014-10-31 17:07:12.07 Server      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-10-31 17:07:13.65 Server      Node configuration: node 0: CPU mask: 0x00000003 Active CPU mask: 0x00000003. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2014-10-31 17:07:14.38 spid7s      Starting up database 'master'.
    2014-10-31 17:07:15.58 spid7s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'SQLEXPRESS'.
    2014-10-31 17:07:16.31 spid7s      SQL Trace ID 1 was started by login "sa".
    2014-10-31 17:07:16.36 spid7s      Starting up database 'mssqlsystemresource'.
    2014-10-31 17:07:16.40 spid7s      The resource database build version is 10.00.2531. This is an informational message only. No user action is required.
    2014-10-31 17:07:16.89 spid7s      Server name is 'JEN_PC\SQLEXPRESS'. This is an informational message only. No user action is required.
    2014-10-31 17:07:16.91 spid10s     Starting up database 'model'.
    2014-10-31 17:07:17.01 spid7s      Informational: No full-text supported languages found.
    2014-10-31 17:07:17.01 spid7s      Starting up database 'msdb'.
    2014-10-31 17:07:18.23 Server      A self-generated certificate was successfully loaded for encryption.
    2014-10-31 17:07:18.31 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQLEXPRESS ].
    2014-10-31 17:07:18.31 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$SQLEXPRESS\sql\query ].
    2014-10-31 17:07:18.29 spid10s     Error: 17204, Severity: 16, State: 1.
    2014-10-31 17:07:18.29 spid10s     FCB::Open failed: Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\model.mdf for file number 1.  OS error: 3(系統找不到指定的路徑。).
    2014-10-31 17:07:18.33 spid7s      Error: 17204, Severity: 16, State: 1.
    2014-10-31 17:07:18.33 spid7s      FCB::Open failed: Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\MSDBData.mdf for file number 1.  OS error: 3(系統找不到指定的路徑。).
    2014-10-31 17:07:18.33 Server      Dedicated administrator connection support was not started because it is disabled on this edition of SQL Server. If you want to use a dedicated administrator connection, restart SQL Server using the trace flag 7806. This is an informational message only. No user action is required.
    2014-10-31 17:07:18.36 spid10s     Error: 5120, Severity: 16, State: 101.
    2014-10-31 17:07:18.36 spid10s     Unable to open the physical file "e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\model.mdf". Operating system error 3: "3(系統找不到指定的路徑。)".
    2014-10-31 17:07:18.50 spid7s      Error: 5120, Severity: 16, State: 101.
    2014-10-31 17:07:18.50 spid7s      Unable to open the physical file "e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\MSDBData.mdf". Operating system error 3: "3(系統找不到指定的路徑。)".
    2014-10-31 17:07:18.58 spid10s     Error: 17207, Severity: 16, State: 1.
    2014-10-31 17:07:18.58 spid10s     FileMgr::StartLogFiles: Operating system error 2(系統找不到指定的檔案。) occurred while creating or opening file 'e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\modellog.ldf'. Diagnose and correct the operating system error, and retry the operation.
    2014-10-31 17:07:18.60 spid10s     File activation failure. The physical file name "e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\modellog.ldf" may be incorrect.
    2014-10-31 17:07:18.65 spid10s     Error: 945, Severity: 14, State: 2.
    2014-10-31 17:07:18.65 spid10s     Database 'model' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.
    2014-10-31 17:07:18.68 spid10s     Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.
    2014-10-31 17:07:18.68 spid7s      Error: 17207, Severity: 16, State: 1.
    2014-10-31 17:07:18.68 spid7s      FileMgr::StartLogFiles: Operating system error 2(系統找不到指定的檔案。) occurred while creating or opening file 'e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\MSDBLog.ldf'. Diagnose and correct the operating system error, and retry the operation.
    2014-10-31 17:07:18.71 spid10s     SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
    2014-10-31 17:07:18.72 spid7s      File activation failure. The physical file name "e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\MSDBLog.ldf" may be incorrect.

    2014年11月3日 上午 01:37
  • 或請告知 如何移除重裝,

    之前有 SQL2005 + MySQL,

    曾看SQL express說無法與 商用版SQL並存, 所以會安裝失敗!...

    所以, 曾於 新增移除程式除除所有的 SQL程式.

    2014年11月3日 上午 01:41
  • 從你的錯誤訊息看起來啟動服務的時候,有許多【統找不到指定的檔案】或【統找不到指定的路徑】的錯誤,請確認這些位置是否有服務所需要的資料夾或檔案。

    另外,如果真的要移除SQL Server 2005可以參考這篇KB。

    http://support2.microsoft.com/kb/909967/zh-tw


    以上說明若有錯誤請指教,謝謝。

    | 台灣 SQL PASS 社群 | SQL PASS Taiwan

    | 歡迎參觀我的BLOG - 積沙成塔

    2014年11月3日 上午 01:47
    版主
  • 上封 SQL Error Log檔案資訊是來自:

    2014年11月3日 上午 03:34
  • Did you put system dbs on e:\ drive? Machine has that disk?
    2014年11月3日 上午 03:44
  • HI,jenwang
    您好,不知版上網友們提供的資料是否對您的問題有幫助
    歡迎您將後續測試結果回報至論壇,或將對您有幫助的回覆標示為解答,
    以利討論的進行並幫助其他有類似問題的朋友。謝謝您!


    歡迎開發者或IT技術工作者同好在開發過程中遇到的問題或相關經驗分享在MSDN論壇上,供大家經驗交流學習
    並請記得將對您有幫助的回覆"標示為解答"以幫助其他尋找解答及參與社群討論的朋友們。

    Please remember to click Mark as Answer on the post that helps you. This can be beneficial to other community members reading the thread.

    2014年11月4日 上午 02:14
  • 安裝時, 並沒有出現任何的Error. 皆可順利完成.

    但, 啟動時失敗.

    所以, 不知該如何解決此一問題??

    2014年11月7日 上午 06:25
  • Dear Sir,

    目前問題是: 啟動 SQL Express時, 無法啟動原因是找不到相關的檔案,

    但, 要如何解決這問題?....尚不知.

    因為, 系統並沒有指示要放入安裝的程式路徑或CD.

    所以, 尚不知要如何修補此問題.

    已重裝2遍了. 安裝時沒有錯誤訊息, 但, 啟動時仍為啟動失敗中...

    2014年11月7日 上午 06:29
  • Does machine have local e:\ disk? Can you fine folder e:\sql10_main_t\sql\mkmastr\databases\objfre\i386 in windows explorer?
    2014年11月7日 下午 01:57