DPM kurulumunda sql...
 
Bildirimler
Hepsini Temizle

DPM kurulumunda sql server sp1 hatası  

 Anonim

Arkadaşlar resimdeki hatayı alıyorum ama ne yaptıysam bulamadım çözümü sql server 2008 sp1 yükledim olmadı ne yapmam lazım.

 

Herkese şimdiden teşekkürler

 

Alıntı
Topic starter Gönderildi : 01/09/2011 16:13
Serkan UZUNER
(@serkanuzuner)
Saygın Üye

Merhaba, sql server versiyonunuzu alabilirmiyiz ? Bunun icin sql konsolu acip help kismindan bakabilirsiniz. Ayrica kurmak istediginiz DPM server'in da tam surumunu alalim, ayni zamanda olay gunlugune dusen logu 

CevapAlıntı
Gönderildi : 01/09/2011 16:53
 Anonim

Teşekkürler serkan bey dediklerinizi yaptım 🙂

Bunlarda loglar

 --------------------------------------------------------------------------------------------

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):           -2068578304
  Exit facility code:            1204
  Exit error code:               0
  Exit message:                  On a domain controller, you cannot use the built-in Windows service accounts (Local Service or Network Service) as service accounts for Reporting Services.
  Start time:                    2011-09-01 14:05:23
  End time:                      2011-09-01 14:05:37
  Requested action:              Install

Machine Properties:
  Machine name:                  WIN-RB61T3D7H90
  Machine processor count:       8
  OS version:                    Windows Server 2008
  OS service pack:               Service Pack 1
  OS region:                     United States
  OS language:                   English (United States)
  OS architecture:               x64
  Process architecture:          64 Bit
  OS clustered:                  No

Product features discovered:
  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered
  Sql Server 2008      MSSQLSERVER          MSSQL10.MSSQLSERVER            Database Engine Services                 1033                 Standard Edition     10.1.2531.0     No        
  Sql Server 2008      MSSQLSERVER          MSSQL10.MSSQLSERVER            SQL Server Replication                   1033                 Standard Edition     10.1.2531.0     No        
  Sql Server 2008      MSSQLSERVER          MSSQL10.MSSQLSERVER            Full-Text Search                         1033                 Standard Edition     10.0.1600.22    No        
  Sql Server 2008      MSSQLSERVER          MSAS10.MSSQLSERVER             Analysis Services                        1033                 Standard Edition     10.1.2531.0     No        
  Sql Server 2008      MSSQLSERVER          MSRS10.MSSQLSERVER             Reporting Services                       1033                 Standard Edition     10.1.2531.0     No        
  Sql Server 2008                                                          Management Tools - Basic                 1033                 Standard Edition     10.1.2531.0     No        
  Sql Server 2008                                                          Management Tools - Complete              1033                 Standard Edition     10.1.2531.0     No        
  Sql Server 2008                                                          Client Tools Connectivity                1033                 Standard Edition     10.1.2531.0     No        
  Sql Server 2008                                                          Client Tools Backwards Compatibility     1033                 Standard Edition     10.1.2531.0     No        
  Sql Server 2008                                                          Client Tools SDK                         1033                 Standard Edition     10.1.2531.0     No        
  Sql Server 2008                                                          Integration Services                     1033                 Standard Edition     10.1.2531.0     No        

Package properties:
  Description:                   SQL Server Database Services 2008
  SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
  ProductName:                   SQL2008
  Type:                          RTM
  Version:                       10
  Installation location:         C:\Users\Administrator\Desktop\DPM2010_EVAL_X64\SQLSVR2008\x64\setup\
  Installation edition:          EVAL

  Slipstream:                    True
  SP Level                       1

User Input Settings:
  ACTION:                        Install
  ADDCURRENTUSERASSQLADMIN:      False
  AGTSVCACCOUNT:                 NT AUTHORITY\SYSTEM
  AGTSVCPASSWORD:                *****
  AGTSVCSTARTUPTYPE:             Manual
  ASBACKUPDIR:                   Backup
  ASCOLLATION:                   Latin1_General_CI_AS
  ASCONFIGDIR:                   Config
  ASDATADIR:                     Data
  ASDOMAINGROUP:                 <empty>
  ASLOGDIR:                      Log
  ASPROVIDERMSOLAP:              1
  ASSVCACCOUNT:                  <empty>
  ASSVCPASSWORD:                 *****
  ASSVCSTARTUPTYPE:              Automatic
  ASSYSADMINACCOUNTS:            <empty>
  ASTEMPDIR:                     Temp
  BROWSERSVCSTARTUPTYPE:         Automatic
  CONFIGURATIONFILE:             C:\Users\Administrator\AppData\Local\Temp\DPM474.tmp\DPM2010\setup\Settings\sqlsettings.ini
  CUSOURCE:                      
  ENABLERANU:                    False
  ERRORREPORTING:                False
  FEATURES:                      SQLENGINE,RS
  FILESTREAMLEVEL:               0
  FILESTREAMSHARENAME:           <empty>
  FTSVCACCOUNT:                  <empty>
  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 DPM\SQL\
  INSTANCEID:                    MSDPM2010EVAL
  INSTANCENAME:                  MSDPM2010EVAL
  ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
  ISSVCPASSWORD:                 *****
  ISSVCSTARTUPTYPE:              Automatic
  NPENABLED:                     0
  PCUSOURCE:                     C:\Users\Administrator\Desktop\DPM2010_EVAL_X64\SQLSVR2008\PCU
  PID:                           *****
  QUIET:                         True
  QUIETSIMPLE:                   False
  RSINSTALLMODE:                 DefaultNativeMode
  RSSVCACCOUNT:                  NT AUTHORITY\NETWORK SERVICE
  RSSVCPASSWORD:                 *****
  RSSVCSTARTUPTYPE:              Automatic
  SAPWD:                         *****
  SECURITYMODE:                  <empty>
  SQLBACKUPDIR:                  <empty>
  SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
  SQLSVCACCOUNT:                 NT AUTHORITY\SYSTEM
  SQLSVCPASSWORD:                *****
  SQLSVCSTARTUPTYPE:             Automatic
  SQLSYSADMINACCOUNTS:           Builtin\Administrators
  SQLTEMPDBDIR:                  <empty>
  SQLTEMPDBLOGDIR:               <empty>
  SQLUSERDBDIR:                  <empty>
  SQLUSERDBLOGDIR:               <empty>
  SQMREPORTING:                  False
  TCPENABLED:                    1
  X86:                           False

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

Detailed results:
  Feature:                       Database Engine Services
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Reporting Services
  Status:                        Failed: see logs for details
  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\20110901_140505\SystemConfigurationCheck_Report.htm

Exception summary:
The following is an exception stack listing the exceptions in outermost to innermost order
Inner exceptions are being indented

Exception type: Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException
    Message:
        On a domain controller, you cannot use the built-in Windows service accounts (Local Service or Network Service) as service accounts for Reporting Services.
    Data:
      DisableWatson = true
    Stack:
        at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.LogAllValidationErrorsAndThrowFirstOne(ValidationState vs)
        at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.ExecuteAction(String actionId)
        at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
        at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
        at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
-------------------------------------------------------

CevapAlıntı
Topic starter Gönderildi : 01/09/2011 17:07
Serkan UZUNER
(@serkanuzuner)
Saygın Üye

Merhaba, 

 

dpm ve sql sunucularini domain controller uzerinde konumlandirmanizi tavsiye etmiyorum. Servislere giderek, (services.msc), baslatma tipine gore siralayip otomatik halde oldugu halde baslamayan servis var mi ona bakalim, ayrica baslamamislarsa baslatmaya calisalim, hata verirse hata kodlarini gonderin, ayrica servis hesaplarinda logon kisminda ne var, o kismi local system e cekip servisleri (sqş servislerini) resetleyip tekrar dpm kurulumu prerequisie checker calistirimisiniz 

CevapAlıntı
Gönderildi : 01/09/2011 17:39
 Anonim

Serkan bey teşekkürler yazdıklarınızı uyguladım şöle yaptım dc üzerinde değilde dc üye olan makinaya kurunca sorunlar gitti kurdum ve gayet iyi çalışıyor teşekkürler.

CevapAlıntı
Topic starter Gönderildi : 01/09/2011 21:35
Serkan UZUNER
(@serkanuzuner)
Saygın Üye

Rica ederim, dc veya exchange gibi kritik servisleri barindiran sunucularda diger hizmetleri kurmanizi istemememizin bir deiger sebebi de, her hangi bir kesinti yapma gereksinimi duydugunuzda bunu mesai saatleri disina ayarlamak zorunda kalmaniz. Ornek olarak dpm uzerinde bir degisiklik yaptiniz ve restart gerektirdi, ama uzerinde dc, exchange gibi roller varsa bu sebeple mesai saati sonrasini beklemek zorunda kalirsiniz.

CevapAlıntı
Gönderildi : 01/09/2011 22:25
 Anonim

Serkan bey tekrar teşekkürler çok yardımcı oldunuz.Bu uyarınızı herzaman dikkate alacam 🙂

CevapAlıntı
Topic starter Gönderildi : 02/09/2011 00:36
Paylaş: