Prerequisite Check Error\Warning

[Flatulent Fox]

I need help getting the Site System to SQL Server Communication Warning cleared out, I'm out of ideas of what else to check. This is in a QA environment, final setup will be a single primary site with a remote sql server.

 

What I have verified:

 

User account doing the install has sysadmin rights to the sql server and local admin rights to sql server and sccm server

 

SCCM computer account has local admin rights to the sql server

 

Windows Firewall are disabled on both sql server and sccm server

 

spn is registered on the sql service account

 

Here's a clip of the log, attached is the full log:

 

INFO: Target Machine <HC1SCCM1QV.mydomain.local>

INFO: SQL Server computer <HC1DBSQ5QV.mydomain.local>

INFO: SQL Server instance <>

INFO: Active Directory Domain is <mydomain>

INFO: Computer Account is <mydomain\HC1SCCM1QV$>

ERROR: Connected to SQL Server but failed to execute query IF NOT EXISTS (select * from master.sys.server_principals where name='mydomain\HC1SCCM1QV$') BEGIN CREATE LOGIN [mydomain\HC1SCCM1QV$] FROM WINDOWS; SELECT 1; END ELSE SELECT 0

save to ini file SQLCONNECT:HC1DBSQ5QV.mydomain.local.

ERROR: Failed to connect to SQL Server HC1SCCM1QV.mydomain.local.

ConfigMgrPrereq.log

[Flatulent Fox]

Figured it out: disjoint namespace issue

 

My company domain and netbios name are not equal

 

work around found here:

 

http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigDisjoint