I have problem with installation of SCCM 2012 with SQL Server 2008 R2 Sp2 (no cumulative updates) installed on the failover cluster.
On cluster I create sysadmin for SQL and this user is local administrator. with this user I installing SCCM:
I got this message:
<11-16-2012 03:31:40> ERROR: Failed to access Firewall Policy Profile.
< 11-16-2012 03:31:40> SCCMSERV.mydomain.com; Firewall exception for SQL Server (stand-alone primary site); Warning; The Windows Firewall is enabled and does not have exceptions configured for SQL Server or the TCP ports that are required for intersite data replication. To resolve this issue, allow sqlservr.exe or the required TCP ports to be accessed remotely. By default, SQL Server listens on TCP port 1433 and the SQL Broker Service uses TCP port 4022, but custom ports might be configured. See ConfigMgrPrereq.log for port details.
>>>> I configure GPO to allow this ports on SCCMSERV and tryed turn off firewall , but problem don't resolve
< 11-16-2012 03:31:40> ERROR: Failed to connect to WMI namespace on MSCLUSTER-SQL.mydomain.com
< 11-16-2012 03:31:40> SCCMSERV.mydomain.com; SQL Server service running account; Error; The logon account for the SQL Server service cannot be a local user account or LOCAL SERVICE. You must configure the SQL Server service to use a valid domain account, NETWORK SERVICE, or LOCAL SYSTEM.
>>>> On SQL failover cluster Sql Server<instance>, Sql Server Agent, Sql server Analysis service configured with domain acconts SQLEngine, SQLAnalysis
< 11-16-2012 04:00:18> MSCLUSTER-SQL.mydomain.com; Site server computer account administrative rights; Error; Configuration Manager Setup requires that the site server computer has administrative rights on the SQL Server and management point computers.
>>>> I'm add SCCM server computer account and user who install sccm to both nodes on failover cluster in local administrators group. Shoud I restart nodes after this?
< 11-16-2012 04:00:18> MSCLUSTER-SQL.mydomain.com; SQL Server security mode; Warning; The SQL Server name specified is configured for SQL authentication security. It is recommended to configure the SQL Server to operate only in Windows authentication security before you continue Configuration Manager Setup.
< 11-16-2012 04:00:18> MSCLUSTER-SQL.mydomain.com; Domain membership; Error; Configuration Manager site server components must be installed on computers that are members of a Windows domain.
I installing on computer that are member of domain.
< 11-16-2012 04:00:18> MSCLUSTER-SQL.mydomain.com; Check SQL Agent service status; Error; The SQL Server Agent service must be enabled.
< 11-16-2012 04:00:18> WARN: SQL Server minimum memory is 0 MB.
< 11-16-2012 04:00:18> MSCLUSTER-SQL.mydomain.com; SQL Server process memory allocation; Warning; Configuration Manager requires SQL Server to reserve a minimum of 8 gigabytes (GB) of memory for the central administration site and primary site and a minimum of 4 gigabytes (GB) for the secondary site. This memory is reserved by using the Minimum server memory setting under Server Memory Options and is configured by using SQL Server Management Studio. For more information about how to set a fixed amount of memory, see http://go.microsoft.com/fwlink/p/?LinkId=233759.
< 11-16-2012 04:00:18> ERROR: Failed to extract NetBIOS name from <MSCLUSTER-SQL.mydomain.com>
< 11-16-2012 04:00:18> MSCLUSTER-SQL.mydomain.com; Primary FQDN; Error; Configuration Manager only supports the use of primary FQDN’s, where the DNS hostname (first label in the FQDN) matches the NetBIOS hostname of the computer. The FQDN provided for this site system does not meet this requirement and cannot be used. Correct the FQDN and try again.
Can you help resolve this problems? Thank you in advance