Jump to content


Sign in to follow this  
vachtang

SCCM 2012 Installation fail on SQL 2008 failover cluster R2 SP2

Recommended Posts

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:

post-11423-0-78095300-1353070469_thumb.png

<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

Share this post


Link to post
Share on other sites


I resolve this problem.

I restarted both nodes and now I have only 2 warnings. I think it hapenned, because I add rights of SCCM computer to both nodes and didn't restart them.

Maybe for somebody it is helpful. :)

Share this post


Link to post
Share on other sites

Hello,need help please

I have problem with installation of SCCM 2012 with SQL Server 2008 R2 Sp2.

Error:

1.Cannot install sccm sdk on windows cluster node

2. cannot install the management point or distribution point site systems role on windows cluster node.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...