locked
FEP 2010, SCCM 2007 R2 y SQL 2008 RRS feed

  • Debate general

  • Hola

    Estoy instalando en el dominio 2 servidores mas:

    -Uno tiene SCCM 2007 R3 (modo nativo) y WSUS 3.0 en un Windows 2008 R2 (se llama: SC3)

    -El segundo tiene SQL SErver 2008 SP 3 en Windows 2008 R2 (se llama: SC2), en este segundo requiero instalar el FEP 2010, sin embargo me manda el error:

    Setup cannot verify the service principal name (SPN) for this account. Ensure that there is a single valid SPN entry for this account in the Active Directory Domain Services.

    Account: domin\mssqlsrv

    Este es el resultado de setspn:

    C:\Users\Administrator.domin>setspn -l domin\mssqlsrv
    Registered ServicePrincipalNames for CN=MS SQL Service,OU=Servicios,DC=domin,DC=local:
            mssqlsrv/sc2.domin.local
            mssqlsrv/sc2
            mssqlsrv/sc2.domin.local:1433
            mssqlsrv/sc2:1433

    Este es parte del log de la instalación:

    [22/05/2012 04:44:38 p.m.][Verbose]  Successfully retrieved database version info: Version: 10.3.5500.0. Service pack: 3.Edition: Enterprise Edition
    [22/05/2012 04:44:38 p.m.][Verbose]  Successfully retrieved SQL service state. Service: MsDtsServer100. State: Running.
    [22/05/2012 04:44:38 p.m.][Verbose]  Successfully retrieved SQL service start mode. Service: MsDtsServer100. State: 2
    [22/05/2012 04:44:38 p.m.][Verbose]  Machine account resolver received machine name 'SC2'
    [22/05/2012 04:44:38 p.m.][Verbose]  Successfully connected to Domain Controller. LDAP path: 'LDAP://domin.local'
    [22/05/2012 04:44:38 p.m.][Verbose]  Successfully constructed AD search filter. Filter: '(&(objectclass=computer)(objectCategory=computer)(cn=SC2))'
    [22/05/2012 04:44:38 p.m.][Verbose]  AD query result contains 'dnsHostName' tag
    [22/05/2012 04:44:38 p.m.][Verbose]  AD query contains 'dnsHostName'. Value: 'SC2.domin.local'
    [22/05/2012 04:44:38 p.m.][Verbose]  AD query contains 'name'. Value: 'SC2'
    [22/05/2012 04:44:38 p.m.][Verbose]  AD query result contains 'objectSid' tag
    [22/05/2012 04:44:38 p.m.][Verbose]  AD query contains 'objectSid'. Value: 'S-1-5-21-3118547275-3601020712-2275677300-1542'
    [22/05/2012 04:44:38 p.m.][Verbose]  SID successfully translated to a NT account name. Account Name: domin\SC2$
    [22/05/2012 04:44:38 p.m.][Verbose]  Successfully retrieved service account info. Service name: MSSQLSERVER. Account name: domin\mssqlsrv. Internal account: 0
    [22/05/2012 04:44:38 p.m.][Verbose]  Retrieved SQL server account: Internal: 'domin\mssqlsrv'; External: 'domin\mssqlsrv'
    [22/05/2012 04:44:38 p.m.][Verbose]  Retrieved SQL SPN: MSSQLSvc/SC2
    [22/05/2012 04:44:38 p.m.][Verbose]  Validating SPN. Account: domin\mssqlsrv. SPN: mssqlsvc/sc2
    [22/05/2012 04:44:38 p.m.][Verbose]  Account translated to SID. Account: domin\mssqlsrv. SID: S-1-5-21-3118547275-3601020712-2275677300-1543
    [22/05/2012 04:44:38 p.m.][Verbose]  Unexpected exception while validating SPN. Exception: System.NullReferenceException: Object reference not set to an instance of an object.
    [22/05/2012 04:44:38 p.m.][Verbose]>    at Microsoft.Forefront.EndpointProtection.Configure.Utility.SqlServerVerifier.ValidateSpn(String spn, String account, String& error)
    [22/05/2012 04:44:38 p.m.][Verbose]  SPN validation failed: Setup cannot verify the service principal name (SPN) for this account. Ensure that there is a single valid SPN entry for this account in the Active Directory Domain Services.
    [22/05/2012 04:44:38 p.m.][Verbose]> Account: domin\mssqlsrv
    [22/05/2012 04:44:38 p.m.][Verbose]  Retrievening SQL version from SC2
    [22/05/2012 04:44:38 p.m.][Verbose] 
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SELECT
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SERVERPROPERTY('ProductVersion') AS ProductVersion,
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SERVERPROPERTY('ProductLevel') AS ProductLevel,
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SERVERPROPERTY('Edition') AS Edition
    [22/05/2012 04:44:38 p.m.][Verbose]  Successfully retrieved database version info: Version: 10.0.5500.0. Service pack: SP3.Edition: Enterprise Edition (64-bit)
    [22/05/2012 04:44:38 p.m.][Verbose]  Successfully retrieved database disk space info: Data location: C. Data space: 39790. Log location: C. Log space: 39790. Server: SC2
    [22/05/2012 04:44:38 p.m.][Verbose]  Retrievening SQL version from SC2
    [22/05/2012 04:44:38 p.m.][Verbose] 
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SELECT
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SERVERPROPERTY('ProductVersion') AS ProductVersion,
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SERVERPROPERTY('ProductLevel') AS ProductLevel,
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SERVERPROPERTY('Edition') AS Edition
    [22/05/2012 04:44:38 p.m.][Verbose]  Successfully retrieved database version info: Version: 10.0.5500.0. Service pack: SP3.Edition: Enterprise Edition (64-bit)
    [22/05/2012 04:44:38 p.m.][Verbose]  Successfully retrieved database disk space info: Data location: C. Data space: 39790. Log location: C. Log space: 39790. Server: SC2
    [22/05/2012 04:44:38 p.m.][Verbose]  Retrievening SQL version from SC2
    [22/05/2012 04:44:38 p.m.][Verbose] 
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SELECT
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SERVERPROPERTY('ProductVersion') AS ProductVersion,
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SERVERPROPERTY('ProductLevel') AS ProductLevel,
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SERVERPROPERTY('Edition') AS Edition
    [22/05/2012 04:44:38 p.m.][Verbose]  Successfully retrieved database version info: Version: 10.0.5500.0. Service pack: SP3.Edition: Enterprise Edition (64-bit)
    [22/05/2012 04:44:38 p.m.][Verbose]  Successfully retrieved service account info. Service name: SQLSERVERAGENT. Account name: domin\mssqlsrv. Internal account: 0
    [22/05/2012 04:44:38 p.m.][Normal]  Successfully retrieved SQL Agent service account. Database server: SC2. Account name: Internal: 'domin\mssqlsrv'; External: 'domin\mssqlsrv'
    [22/05/2012 04:44:38 p.m.][Verbose]  Retrievening SQL version from SC2
    [22/05/2012 04:44:38 p.m.][Verbose] 
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SELECT
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SERVERPROPERTY('ProductVersion') AS ProductVersion,
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SERVERPROPERTY('ProductLevel') AS ProductLevel,
    [22/05/2012 04:44:38 p.m.][Verbose]>                     SERVERPROPERTY('Edition') AS Edition
    [22/05/2012 04:44:38 p.m.][Verbose]  Successfully retrieved database version info: Version: 10.0.5500.0. Service pack: SP3.Edition: Enterprise Edition (64-bit)
    [22/05/2012 04:44:38 p.m.][Normal]  Successfully retrieved SQL Server version. Database server: SC2.  Version: Sql2008.
    [22/05/2012 04:44:38 p.m.][Verbose]  Successfully retrieved service account info. Service name: SQLSERVERAGENT. Account name: domin\mssqlsrv. Internal account: 0
    [22/05/2012 04:44:38 p.m.][Normal]  Successfully retrieved SQL Agent service account. Database server: SC2. Account name: Internal: 'domin\mssqlsrv'; External: 'domin\mssqlsrv'
    [22/05/2012 04:44:38 p.m.][Verbose]  Successfully retrieved service account info. Service name: MSSQLServerOLAPService. Account name: domin\mssqlsrv. Internal account: 0
    [22/05/2012 04:44:38 p.m.][Normal]  Successfully retrieved SQL Analysis Services service account. Database server: SC2. Account name: Internal: 'domin\mssqlsrv'; External: 'domin\mssqlsrv'
    [22/05/2012 04:44:38 p.m.][Verbose]  Info: Successfully deduced account set for granting access permissions between different components. Accounts: Alert Service account for reporting database: 0x010100000000000514000000
    [22/05/2012 04:44:38 p.m.][Verbose]> Alert Service account for external computers: domin\SC2$
    [22/05/2012 04:44:38 p.m.][Verbose]> Reporting database SQL Agent account for Configuration Manager database: 0x0105000000000005150000004b41e1b92837a3d67414a48707060000
    [22/05/2012 04:44:38 p.m.][Verbose]> Reporting database SQL Agent account for Reporting database: 0x0105000000000005150000004b41e1b92837a3d67414a48707060000
    [22/05/2012 04:44:38 p.m.][Verbose]> Reporting database Analysis Services service account for Reporting database: 0x0105000000000005150000004b41e1b92837a3d67414a48707060000
    [22/05/2012 04:44:38 p.m.][Verbose]> Configuration Manager database SQL Agent account for Configuration Manager database: 0x0105000000000005150000004b41e1b92837a3d67414a48707060000
    [22/05/2012 04:44:39 p.m.][Normal]  Verification(SQL Server prerequisite) failed
    [22/05/2012 04:44:39 p.m.][Normal]> Setup cannot verify the service principal name (SPN) for this account. Ensure that there is a single valid SPN entry for this account in the Active Directory Domain Services.
    [22/05/2012 04:44:39 p.m.][Normal]> Account: domin\mssqlsrv
    [22/05/2012 04:44:39 p.m.][Normal]>
    [22/05/2012 04:44:39 p.m.][Normal]>
    [22/05/2012 04:44:39 p.m.][Normal]>
    [22/05/2012 04:44:39 p.m.][Verbose]  Retrievening SQL version from SC2
    [22/05/2012 04:44:39 p.m.][Verbose] 
    [22/05/2012 04:44:39 p.m.][Verbose]>                     SELECT
    [22/05/2012 04:44:39 p.m.][Verbose]>                     SERVERPROPERTY('ProductVersion') AS ProductVersion,
    [22/05/2012 04:44:39 p.m.][Verbose]>                     SERVERPROPERTY('ProductLevel') AS ProductLevel,
    [22/05/2012 04:44:39 p.m.][Verbose]>                     SERVERPROPERTY('Edition') AS Edition
    [22/05/2012 04:44:39 p.m.][Verbose]  Successfully retrieved database version info: Version: 10.0.5500.0. Service pack: SP3.Edition: Enterprise Edition (64-bit)
    [22/05/2012 04:44:39 p.m.][Verbose]  OLAP Server roles Administrators
    [22/05/2012 04:44:39 p.m.][Verbose]  Detected installed SQL Analysis Services client. Version: 10.0.5500.0. Edition: Enterprise64
    [22/05/2012 04:44:39 p.m.][Normal]  Verification(Verifying SQL Analysis Services version) passed
    [22/05/2012 04:44:39 p.m.][Normal]> SQL Analysis Services version: 10.0.5500.0 (Enterprise64)
    [22/05/2012 04:44:39 p.m.][Normal]>
    [22/05/2012 04:44:39 p.m.][Normal]>
    [22/05/2012 04:44:39 p.m.][Normal]>
    [22/05/2012 04:44:39 p.m.][Verbose]  Sending HTTP request to http://sc2.domin.local/ReportServer/ReportService2005.asmx:
    [22/05/2012 04:44:39 p.m.][Verbose]> <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="<soap:Body><ListSecureMethods">http://www.w3.org/2001/XMLSchema"><soap:Body><ListSecureMethods xmlns="http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices" /></soap:Body></soap:Envelope>
    [22/05/2012 04:44:39 p.m.][Verbose]  SOAP Action: http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListSecureMethods
    [22/05/2012 04:44:39 p.m.][Verbose]  Successfully received HTTP response:
    [22/05/2012 04:44:39 p.m.][Verbose]> <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="<soap:Header><ServerInfoHeader">http://www.w3.org/2001/XMLSchema"><soap:Header><ServerInfoHeader xmlns="<ReportServerVersionNumber>2007.100.5500.00</ReportServerVersionNumber><ReportServerEdition>Enterprise</ReportServerEdition><ReportServerVersion>Microsoft">http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices"><ReportServerVersionNumber>2007.100.5500.00</ReportServerVersionNumber><ReportServerEdition>Enterprise</ReportServerEdition><ReportServerVersion>Microsoft SQL Server Reporting Services Version 10.0.5500.0</ReportServerVersion><ReportServerDateTime>2012-05-22T16:44:39</ReportServerDateTime></ServerInfoHeader></soap:Header><soap:Body><ListSecureMethodsResponse xmlns="<ListSecureMethodsResult">http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices"><ListSecureMethodsResult /></ListSecureMethodsResponse></soap:Body></soap:Envelope>
    [22/05/2012 04:44:39 p.m.][Verbose]  SQL Reporting Services version: Microsoft SQL Server Reporting Services Version 10.0.5500.0, Enterprise, 2012-05-22T16:44:39
    [22/05/2012 04:44:43 p.m.][Normal]  Verification(Verifying SQL Reporting Services prerequisite) passed
    [22/05/2012 04:44:43 p.m.][Normal]>
    [22/05/2012 04:44:44 p.m.][Verbose]  Successfully retrieved site version info: Actual: 4.0.6487.2000. Minimum: 4.0.6487.2000. Maximim: 5.0.0.0. R2 Deployed: True. Status: 0
    [22/05/2012 04:44:44 p.m.][Normal]  Verification(Verifying Configuration Manager version) passed
    [22/05/2012 04:44:44 p.m.][Normal]>
    [22/05/2012 04:44:44 p.m.][Normal]  About to verify Configuration Manager Site Server permissions
    [22/05/2012 04:44:44 p.m.][Verbose]  Validating required permissions:
    [22/05/2012 04:44:44 p.m.][Verbose]> Class: Site Permission: Read, Modify, Administer
    [22/05/2012 04:44:44 p.m.][Verbose]> Class: Collection Permission: Read, Read resource, Modify, Modify Resource, Modify collection setting, Delete, Delete resource, Create, Advertise, Administer
    [22/05/2012 04:44:44 p.m.][Verbose]> Class: Configuration items Permission: Read, Modify, Delete, Create, Distribute, Manage folder
    [22/05/2012 04:44:45 p.m.][Normal]  Verification(Verifying Configuration Manager Site Server permissions) passed
    [22/05/2012 04:44:45 p.m.][Normal]>
    [22/05/2012 04:44:45 p.m.][Verbose]  Successfully retrieved client component flags. Flags: 1
    [22/05/2012 04:44:45 p.m.][Normal]  About to verify client component Desired Configuration Management Client Agent is enabled
    [22/05/2012 04:44:45 p.m.][Verbose]  Successfully retrieved client component flags. Flags: 1
    [22/05/2012 04:44:46 p.m.][Normal]  About to verify client component Hardware Inventory Client Agent is enabled
    [22/05/2012 04:44:46 p.m.][Verbose]  Successfully retrieved client component flags. Flags: 1
    [22/05/2012 04:44:46 p.m.][Normal]  About to verify client component Advertised Programs Client Agent is enabled
    [22/05/2012 04:44:46 p.m.][Verbose]  Retrievening SQL version from SC2
    [22/05/2012 04:44:46 p.m.][Verbose] 
    [22/05/2012 04:44:46 p.m.][Verbose]>                     SELECT
    [22/05/2012 04:44:46 p.m.][Verbose]>                     SERVERPROPERTY('ProductVersion') AS ProductVersion,
    [22/05/2012 04:44:46 p.m.][Verbose]>                     SERVERPROPERTY('ProductLevel') AS ProductLevel,
    [22/05/2012 04:44:46 p.m.][Verbose]>                     SERVERPROPERTY('Edition') AS Edition
    [22/05/2012 04:44:46 p.m.][Verbose]  Successfully retrieved database version info: Version: 10.0.5500.0. Service pack: SP3.Edition: Enterprise Edition (64-bit)
    [22/05/2012 04:44:46 p.m.][Verbose]  Successfully retieved SQL CLR support status: True
    [22/05/2012 04:44:46 p.m.][Normal]  Verification(Verifying Configuration Manager client components) passed
    [22/05/2012 04:44:46 p.m.][Normal]>
    [22/05/2012 04:44:46 p.m.][Verbose]  Accessing registry. Tree: LocalMachine. Key path: 'SOFTWARE\Microsoft\ConfigMgr\Setup'. Value name: 'Full UI Version'
    [22/05/2012 04:44:46 p.m.][Verbose]  RegOpenKeyEx return code: 0
    [22/05/2012 04:44:46 p.m.][Verbose]  RegQueryValueEx return code: 0
    [22/05/2012 04:44:46 p.m.][Verbose]  Registry key value: 4.00.6487.2000
    [22/05/2012 04:44:46 p.m.][Verbose]  Configuration Manager console version '4.0.6487.2000', going to perform QFE check
    [22/05/2012 04:44:46 p.m.][Verbose]  Searching for registry key. Tree: LocalMachine. Parent key path: 'SOFTWARE\Microsoft\Updates\System Center Configuration Manager 2007\SP2'. Predicate: 'System.Predicate`1[System.String]'
    [22/05/2012 04:44:46 p.m.][Verbose]  RegOpenKeyEx return code: 0
    [22/05/2012 04:44:46 p.m.][Verbose]  RegEnumKeyEx return code: 0
    [22/05/2012 04:44:46 p.m.][Verbose]  Retrieved key name: KB2271736
    [22/05/2012 04:44:46 p.m.][Verbose]  Lookup successfully completed
    [22/05/2012 04:44:46 p.m.][Verbose]  QFE 'KB2271736' is installed, Configuration Manager console version passed prerequisite check
    [22/05/2012 04:44:46 p.m.][Normal]  Verification(Verifying Configuration Manager console prerequisite) passed
    [22/05/2012 04:44:46 p.m.][Normal]>
    [22/05/2012 04:44:46 p.m.][Normal]  Verification(Verifying restart is not required) passed
    [22/05/2012 04:44:46 p.m.][Normal]>
    [22/05/2012 04:44:46 p.m.][Normal]  Finished running verifications.

    ¿Alguna idea? es bien recibida, gracias de antemano.


    Doc MX

    • Tipo cambiado DocMX jueves, 7 de junio de 2012 22:33 Encontre una solución
    martes, 22 de mayo de 2012 21:49

Todas las respuestas

  • Hola

    Ya encontre el problema, y aunque no es la solución exacta, el workaround que realize funciono a la perfección:

    Lo que observe en el archivo de log es  esto:

    [22/05/2012 04:44:38 p.m.][Verbose]  Retrieved SQL server account: Internal: 'domin\mssqlsrv'; External: 'domin\mssqlsrv'
    [22/05/2012 04:44:38 p.m.][Verbose]  Retrieved SQL SPN: MSSQLSvc/SC2

    Dentro del SQL Server, la cuenta que tiene definida como SPN es MSSQLSvc y yo estaba intentando hacer que tomara la cuenta MSSQLSRV, asi que lo que realice fue crear una cuenta que se llamara MSSQLSVC, le asigne password, la adicione al grupo de SQL Admins y listo, funciono a la perfección la instalación.

    Espero que les sea de utilidad.

    Saludos!


    Doc MX

    jueves, 7 de junio de 2012 22:32