C#nedir?com Homepage
Forum Home Forum Home > Veritabanları > SQL Server
  New Posts New Posts RSS Feed - Sql Server Database Engine Services Failed Hatası
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Sql Server Database Engine Services Failed Hatası

 Post Reply Post Reply
   

Author
Message
Darkened View Drop Down
Groupie
Groupie


Joined: 25 Ocak 2009
Location: Turkey
Status: Offline
Points: 44
Post Options Post Options   Thanks (0) Thanks(0)   Quote Darkened Quote  Post ReplyReply Direct Link To This Post Topic: Sql Server Database Engine Services Failed Hatası
    Posted: 25 Eylül 2014 at 03:23
Windows 8'e Sql Server 2008 R2 kurmaya çalışıyorum. Kaç defa denedim ne yaparsam yapayım "Database Engine Services Failed" hatası veriyor. Sql dosyalarım bozuk olamaz veya benim kurulum konusunda yanlışım olamaz çünkü aynısını Windows 7'e kuruyorum sorunsuz kuruluyor ve çalışıyor. Yaptıklarım;

* Bilgisayarda sql ile alakalı herşeyi kaldırıyorum.
* Registry den sql ile alakalı tüm key leri siliyorum.
* Restart ediyorum kuruluma tekrar geçiyorum. Kurulumun yarısında "Database Engine Services Failed" diyor, diğerleri başarılı ve Sql Server çalışmayı durdurdu diyerek kurulum sonlanıyor.
* Güvenlik duvarım kapalı. Antivirüs programı yok.
* Güvenlik duvarında 1433 port'a izin verdim.

Kurulum Hatalı sonlansa bile Management Studio geliyor ancak doğal olarak veritabanı bağlantısı kuramıyorum.
Back to Top
seser View Drop Down
Senior Member
Senior Member


Joined: 04 Temmuz 2005
Status: Offline
Points: 4654
Post Options Post Options   Thanks (0) Thanks(0)   Quote seser Quote  Post ReplyReply Direct Link To This Post Posted: 25 Eylül 2014 at 16:04
servislere sql server gelmiş mi? başlatılabiliyor mu?
detaylı log dosyasını gönder.
acil durumda camı kırınız!
Back to Top
Darkened View Drop Down
Groupie
Groupie


Joined: 25 Ocak 2009
Location: Turkey
Status: Offline
Points: 44
Post Options Post Options   Thanks (0) Thanks(0)   Quote Darkened Quote  Post ReplyReply Direct Link To This Post Posted: 25 Eylül 2014 at 23:08
Merhabalar, öncelikle yanıt için teşekkür ederim.

SQLDUMPER_ERRORLOG.log dosyası var içinde şu yazıyor;

(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () completed with status (00000514)
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,      Parameter 1: 1484
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,      Parameter 2: 0
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,      Parameter 3: 0:0
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,      Parameter 4: 0000000003D15C40
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters:
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ProcessID = 1484
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ThreadId = 0
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     Flags = 0x0
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     MiniDumpFlags = 0x0
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     SqlInfoPtr = 0x0000000003D15C40
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     DumpDir = <NULL>
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ExceptionRecordPtr = 0x0000000000000000
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ContextPtr = 0x0000000000000000
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ExtraFile = <NULL>
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     InstanceName = <NULL>
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ServiceName = <NULL>
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Threads processed: 16
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
(1970:1694) 09/25/14 22:48:39, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
(1970:1694) 09/25/14 22:48:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
(1970:1694) 09/25/14 22:48:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log\SQLDmpr0001.mdmp
(1970:1694) 09/25/14 22:48:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll'
(1970:1694) 09/25/14 22:48:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(1970:1694) 09/25/14 22:48:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(1970:1694) 09/25/14 22:48:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE'
(1970:1694) 09/25/14 22:48:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2009.100:1600.1'
(1970:1694) 09/25/14 22:48:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.50:1600.1'
(1970:1694) 09/25/14 22:48:40, ERROR ,               msmdsrv.exe, Unable to open file \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log\FlightRecorderCurrent.trc, error 2
(1970:1694) 09/25/14 22:48:40, ACTION,               msmdsrv.exe, Watson Invoke: No


Bir de msmdsrv.log dosyası var şunu yazıyor;

(25.9.2014 22:48:39) Message: Failed to initialize SQLSQM timer. One of the following can be the source of the problem: registry doesn't contain all necessary information, server instance name can not be retrieved correctly, failure during timer creation, etc. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC121001B)
(9/25/2014 10:48:41 PM) Message: The file '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\CryptKey.bin' could not be opened. Please check the file for permissions or see if other applications locked it. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210023)
(9/25/2014 10:48:44 PM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/25/2014 10:48:44 PM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)






Bir de Başarısız kurulumların bir tanesine ait olan Summary.log dosyasında yazan şu;



Overall summary:
Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
Exit code (Decimal):           -2068052377
Exit facility code:            1212
Exit error code:               1639
Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
Start time:                    2014-09-25 22:30:27
End time:                      2014-09-25 22:48:53
Requested action:              Install
Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140925_222945\sql_engine_core_inst_Cpu64_1.log
Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.2500.0

Machine Properties:
Machine name:                  CAGATAY
Machine processor count:       4
OS version:                    Future Windows Version
OS service pack:              
OS region:                     United States
OS language:                   Türkçe (Türkiye)
OS architecture:               x64
Process architecture:          64 Bit
OS clustered:                  No

Product features discovered:
Product              Instance             Instance ID                    Feature                                  Language             Edition              Version        Clustered

Package properties:
Description:                   SQL Server Database Services 2008 R2
ProductName:                   SQL Server 2008 R2
Type:                          RTM
Version:                      10
SPLevel:                      1
Installation location:        C:\Users\cagatay\Desktop\Microsoft SQL Server 2008 R2\x64\setup\
Installation edition:          DEVELOPER

User Input Settings:
ACTION:                        Install
ADDCURRENTUSERASSQLADMIN:      False
AGTSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
AGTSVCPASSWORD:               *****
AGTSVCSTARTUPTYPE:             Manual
ASBACKUPDIR:                   C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Backup
ASCOLLATION:                   Turkish_CI_AS
ASCONFIGDIR:                   C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Config
ASDATADIR:                     C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data
ASDOMAINGROUP:                 <empty>
ASLOGDIR:                      C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log
ASPROVIDERMSOLAP:              1
ASSVCACCOUNT:                  NT AUTHORITY\NETWORK SERVICE
ASSVCPASSWORD:                 *****
ASSVCSTARTUPTYPE:              Automatic
ASSYSADMINACCOUNTS:            CAGATAY\cagatay
ASTEMPDIR:                     C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Temp
BROWSERSVCSTARTUPTYPE:        Disabled
CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140925_222945\ConfigurationFile.ini
CUSOURCE:                     
ENABLERANU:                    False
ENU:                           True
ERRORREPORTING:               False
FARMACCOUNT:                   <empty>
FARMADMINPORT:                 0
FARMPASSWORD:                  *****
FEATURES:                      SQLENGINE,REPLICATION,FULLTEXT,AS,RS,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK
FILESTREAMLEVEL:               0
FILESTREAMSHARENAME:           <empty>
FTSVCACCOUNT:                  NT AUTHORITY\LOCAL SERVICE
FTSVCPASSWORD:                 *****
HELP:                          False
INDICATEPROGRESS:              False
INSTALLSHAREDDIR:              c:\Program Files\Microsoft SQL Server\
INSTALLSHAREDWOWDIR:           c:\Program Files (x86)\Microsoft SQL Server\
INSTALLSQLDATADIR:             <empty>
INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
INSTANCEID:                    MSSQLSERVER
INSTANCENAME:                  MSSQLSERVER
ISSVCACCOUNT:                  NT AUTHORITY\NETWORK SERVICE
ISSVCPASSWORD:                 *****
ISSVCSTARTUPTYPE:              Automatic
NPENABLED:                     0
PASSPHRASE:                    *****
PCUSOURCE:                     
PID:                           *****
QUIET:                         False
QUIETSIMPLE:                   False
ROLE:                          <empty>
RSINSTALLMODE:                 DefaultNativeMode
RSSVCACCOUNT:                  NT AUTHORITY\NETWORK SERVICE
RSSVCPASSWORD:                 *****
RSSVCSTARTUPTYPE:              Automatic
SAPWD:                         *****
SECURITYMODE:                  SQL
SQLBACKUPDIR:                  <empty>
SQLCOLLATION:                  Turkish_CI_AS
SQLSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
SQLSVCPASSWORD:               *****
SQLSVCSTARTUPTYPE:             Automatic
SQLSYSADMINACCOUNTS:           CAGATAY\cagatay
SQLTEMPDBDIR:                  <empty>
SQLTEMPDBLOGDIR:               <empty>
SQLUSERDBDIR:                  <empty>
SQLUSERDBLOGDIR:               <empty>
SQMREPORTING:                  False
TCPENABLED:                    0
UIMODE:                        Normal
X86:                           False

Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140925_222945\ConfigurationFile.ini

Detailed results:
Feature:                      Database Engine Services
Status:                        Failed: see logs for details
MSI status:                    Failed: see details below
MSI error code:               0x1639
MSI log file location:        C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140925_222945\sql_engine_core_inst_Cpu64_1.log
MSI error description:       
Configuration status:          Passed

Feature:                      SQL Client Connectivity SDK
Status:                        Passed
MSI status:                    Passed
Configuration status:          Passed

Feature:                      SQL Server Replication
Status:                        Failed: see logs for details
MSI status:                    Failed: see details below
MSI error code:               0x1639
MSI log file location:        C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140925_222945\sql_engine_core_inst_Cpu64_1.log
MSI error description:       
Configuration status:          Passed

Feature:                      Full-Text Search
Status:                        Failed: see logs for details
MSI status:                    Failed: see details below
MSI error code:               0x1639
MSI log file location:        C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140925_222945\sql_engine_core_inst_Cpu64_1.log
MSI error description:       
Configuration status:          Passed

Feature:                      Analysis Services
Status:                        Passed
MSI status:                    Passed
Configuration status:          Passed

Feature:                      Reporting Services
Status:                        Failed: see logs for details
MSI status:                    Failed: see details below
MSI error code:               0x1639
MSI log file location:        C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140925_222945\sql_engine_core_inst_Cpu64_1.log
MSI error description:       
Configuration status:          Passed

Feature:                      Integration Services
Status:                        Passed
MSI status:                    Passed
Configuration status:          Passed

Feature:                      Client Tools Connectivity
Status:                        Passed
MSI status:                    Passed
Configuration status:          Passed

Feature:                      Management Tools - Complete
Status:                        Passed
MSI status:                    Passed
Configuration status:          Passed

Feature:                      Management Tools - Basic
Status:                        Passed
MSI status:                    Passed
Configuration status:          Passed

Feature:                      Client Tools SDK
Status:                        Passed
MSI status:                    Passed
Configuration status:          Passed

Feature:                      Client Tools Backwards Compatibility
Status:                        Passed
MSI status:                    Passed
Configuration status:          Passed

Feature:                      Business Intelligence Development Studio
Status:                        Passed
MSI status:                    Passed
Configuration status:          Passed

Feature:                      SQL Server Books Online
Status:                        Passed
MSI status:                    Passed
Configuration status:          Passed

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140925_222945\SystemConfigurationCheck_Report.htm





Edited by Darkened - 26 Eylül 2014 at 04:06
Back to Top
Darkened View Drop Down
Groupie
Groupie


Joined: 25 Ocak 2009
Location: Turkey
Status: Offline
Points: 44
Post Options Post Options   Thanks (0) Thanks(0)   Quote Darkened Quote  Post ReplyReply Direct Link To This Post Posted: 25 Eylül 2014 at 23:23
Mesela SA kullanıcısı için girdiğim şifreyi deniyorum;

Aşağıdaki screenshot daki hatayı alıyorum;



Edited by Darkened - 25 Eylül 2014 at 23:23
Back to Top
Darkened View Drop Down
Groupie
Groupie


Joined: 25 Ocak 2009
Location: Turkey
Status: Offline
Points: 44
Post Options Post Options   Thanks (0) Thanks(0)   Quote Darkened Quote  Post ReplyReply Direct Link To This Post Posted: 29 Eylül 2014 at 01:36
Bu konuda maalesef hala sonuç yok, Windows 8 ile Sql Server arasında bir uyumsuzluk sorunu mu var?

Bu sefer o hata verdiği yeri geçti ancak bitime yakın şu hatayı verdi;



Ve sonuç olarakta kurulum şu şekilde Failed lar ile bitti;



Edited by Darkened - 29 Eylül 2014 at 01:37
Back to Top
seser View Drop Down
Senior Member
Senior Member


Joined: 04 Temmuz 2005
Status: Offline
Points: 4654
Post Options Post Options   Thanks (0) Thanks(0)   Quote seser Quote  Post ReplyReply Direct Link To This Post Posted: 29 Eylül 2014 at 09:02
win8 ile sql server uyumunda problem yok.

servislerde sql server var mı?
acil durumda camı kırınız!
Back to Top
Darkened View Drop Down
Groupie
Groupie


Joined: 25 Ocak 2009
Location: Turkey
Status: Offline
Points: 44
Post Options Post Options   Thanks (0) Thanks(0)   Quote Darkened Quote  Post ReplyReply Direct Link To This Post Posted: 29 Eylül 2014 at 09:55
Kurulumdan sonra servisler içinde geliyor mu diye soruyorsunuz?
Back to Top
seser View Drop Down
Senior Member
Senior Member


Joined: 04 Temmuz 2005
Status: Offline
Points: 4654
Post Options Post Options   Thanks (0) Thanks(0)   Quote seser Quote  Post ReplyReply Direct Link To This Post Posted: 29 Eylül 2014 at 12:09
evet
servisler oluşmuş ise, 2. kurulumun hata vermesi normal.

bazen hata sadece servisin başlatılması olabiliyor.

Edited by seser - 29 Eylül 2014 at 12:10
acil durumda camı kırınız!
Back to Top
ademturman View Drop Down
Newbie
Newbie


Joined: 18 Mart 2016
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote ademturman Quote  Post ReplyReply Direct Link To This Post Posted: 18 Mart 2016 at 11:07
İlk defa kurmak önemli eğer kurulum tam değilse pek çok problemle yaşatıyor.

Eğer Connect to Server hatası alıyorsanız. "services.msc" ile sistemde olan sql hizmetlerinin hepsini "otomatik" yapın ve Bilgisayar Yönetimi >> SQL Server Services >> (Kurduğunuz ServerName) artık ne ise tekrar başlatın eğer duruyorsa başlatı seçin.

Baktınız gene olmadı. Tamamen sistemden uninstall programları ile Örn; Boospeed Uninstall Manager gibi programlarla kaldırın. Kullandığınız programın "regedit" kayıt defterinden kayıtlı olan herşeyi sildiğinden emin olun. Sistem diskinden ve Belgelerim , AppData >> Users vs klasörlerden silin eğer silme hatası alıyorsanız "Görev Yöneticisi" nden durdurun ve tekrar kaldırın.

Hepsini denediniz olmadı ise format atın.)

İyi Kodlamalar.)
Back to Top
 Post Reply Post Reply
  Share Topic   
   


Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.01
Copyright ©2001-2014 Web Wiz Ltd.