17 nov 2012

SCCM by Davis

SCCM by Davis


Count of Video Controller details.

Posted: 17 Nov 2012 12:58 PM PST

For full details, please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/38f8a5c1-3b82-4ca4-b664-167b6c8226c5

 

select      r.netbios_name0 as nm,      Count(r.netbios_name0)  from      v_GS_VIDEO_CONTROLLER vc      join v_R_System R on VC.ResourceID = R.ResourceID  where      vc.CurrentHorizontalResolution0 not like ''  Group by      r.netbios_name0  order by       R.netbios_name0

SCCM 2012 : "A communication error has been detected between the specified site system and the site database computer"

Posted: 28 Sep 2012 12:13 PM PDT

Hi,

Currently, I am working on an important System Center project. During SCCM 2012 installation, I have encountered this error in the pre requisites checking step :

"Site System to SQL Server Communication;    Warning;    A communication error has been detected between the specified site system and the site database computer. This error can occur when the site database server is offline or if a valid SPN has not been registered in Active Directory Domain Services for the SQL Server instance hosting the site database. Setup cannot continue."

In my case, the database server is hosted on a remote server. I have done all the necessary configurations. But this error occurred. I have applied consequently the suggestion of registering the SPN of the SQL instance. That did not solve my issue. Don't forget of course to fix the SQL communication ports, because the dynamic ports when you have more than one instance cause many problems.

So I consulted the log file to analyze the issue and surprise ! I got these wonderful lines :

<09-16-2012 15:27:25> ERROR: Connected to SQL Server but failed to execute query IF NOT EXISTS (select * from master.sys.server_principals where name='DOMAIN\SCCMCOMPUTERACCOUNT$') BEGIN CREATE LOGIN [DOMAIN\SCCMCOMPUTERACCOUNT$] FROM WINDOWS; SELECT 1; END ELSE SELECT 0
<09-16-2012 15:27:25> save to ini file SQLCONNECT:DatabaseServerAccount\cmsql.
<09-16-2012 15:27:31> ERROR: Failed to connect to SQL Server SCCMCOMPUTERName.

So I have verified the logins section in my SQL Server and really the account was not created. What's the matter?

To understand the issue, try to execute the T-SQL query and bingo! this account cannot be retrieved and verified.

In my case, the NetBios domain name is different from the domain name without DNS suffix. The wizard detects the domain name and simply extracts the NetBios name by removing the DNS suffix like .com for example.

Let us suppose that your domain name is CONTOSO.COM. the SCCM wizard just extracts CONTOSO and considers it as the NetBios name, even it is different. After that, an account name is generated for your SCCM computer account using the extracted NetBios name. if the real NetBios name is different so the generated account is false and does not exist.

What to do?

Simply execute the SQL request by putting the real account name. you will notice that the request is executed successfully. Don't attribute privileges, the wizard does it for you.

Now, when you relaunch the wizard the error sill exists but don't worry, you can continue without any problem.

You will also have the following AD container errors even you have configured the necessary settings :

<09-16-2012 15:27:14> ERROR: Site server does not have create child permission on AD 'System Management'
<09-16-2012 15:27:14> WARN: Site server does not have delete child permission on AD 'System Management'
<09-16-2012 15:27:16> SCCMComputerName; Verify site server permissions to publish to Active Directory.; Warning; The site server might be unable to publish to Active Directory. The computer account for the site server must have Full Control permissions to the System Management container in its Active Directory domain. You can ignore this warning if you have manually verified these permissions. For more information about your options to configure required permissions, see http://go.microsoft.com/fwlink/p/?LinkId=233190.

Don't worry, the error is due to the same reason and you can install the SCCM without any problem.

After installation please check your SQL server to verify the database creation and that the account you have created previously is attributed the right rights. Please check also the System management container in the AD and verify the information publication.

The limit of Software Inventory rules

Posted: 28 Sep 2012 07:53 AM PDT

On the Inventory Collection tab of the Software Inventory Client Agent Properties recently I have stumbled upon an issue where the New icon has been greyed out and disabled, not allowing me add any new rules defining the software inventory scope.

Image

After some googling around, this behaviour turned out to be documented and by design. In Configuration Manager 2007, there is a maximum limit of 64 rules. I am not sure if it is applicable to Configuration Manager 2012 as well, but it is worth to keep this limit in mind. Sometimes you learn things which are well documented the hard way.

For more information, refer to the Configuring Software Inventory Rules article on Microsoft Technet – http://technet.microsoft.com/en-us/library/cc181215.aspx

SCCM 2012: Clients cannot install deployed update packs. Error 0x87D00692

Posted: 28 Sep 2012 07:52 AM PDT

Issue: SCCM Clients cannot install deployed updates.

Resolution: Check your deployment status either in console, or using SCCM report  (Software Updates – E Troubleshooting/Troubleshooting 2 – Deployment errors)

image

The cause of failure is "GPO conflict". Domain GPO overwrites SCCM Client settings and points the machine to corporate WSUS server. That is why Client cannot use SUP for update evaluation. It is necessary to either set GPO settings for Intranet Windows Update Server to "Not Configured" and let SCCM client configure local policy properly or put SUP FQDN and port instead of WSUS into GPO. If you are in migration and not ready to repoint all machines to SCCM  you can configure GPO to repoint the settings to SCCM for SCCM clients only using WMI filter (see more here )

Vitaly Gritsenko became a registered member

Posted: 17 Nov 2012 05:38 AM PST

Comments: 0

Sumo Logic Tracks Network Performance Through Event Logs

Posted: 16 Nov 2012 04:30 PM PST

The data analytics service studies reams of data about a client's network and applications to learn about the network's performance and to find ways to improve it.

Pete Pfunck commented on the post, ConfigMgr 2012 Powershell Right Click Tools Update

Posted: 16 Nov 2012 02:34 PM PST

I had similar issue, try the fix below:

Run: regedit

* Goto HKEY_LOCAL_MACHINESOFTWAREMicrosoftPowerShell

* Right-Click > Permissions

* Select, and add your account, grant it "Full Control" […]

Comments: 0

John Hamilton joined the group System Center Configuration Manager 2007

Posted: 16 Nov 2012 01:40 PM PST

Comments: 0

SCCM by Davis

Posted: 16 Nov 2012 01:34 PM PST

SCCM by Davis


Rod Trent wrote a new post, Infographic: The power hungry Internet

Posted: 16 Nov 2012 10:51 AM PST

ThumbnailIt's amazing how much the Internet and it's usage has grown. I can kind of remember I time without it, but that seems so very long ago now.

Compiled By: WirelesSatelliteInternet.org

Comments: 0

Brooke Owens joined the group System Center Jobs

Posted: 16 Nov 2012 10:30 AM PST

Comments: 0

Brooke Owens joined the group Ron's Web Essentials

Posted: 16 Nov 2012 10:30 AM PST

Comments: 0

Brooke Owens joined the group Operating System Deployment

Posted: 16 Nov 2012 10:29 AM PST

Comments: 0

Brooke Owens joined the group System Center Configuration Manager 2012

Posted: 16 Nov 2012 10:28 AM PST

Comments: 0

Brooke Owens joined the group SCCM Right-click tools

Posted: 16 Nov 2012 10:28 AM PST

Comments: 0

Rod Trent posted an update in the group IT Fit: Science Launches Urban Remedy To Bring Healthy Juices, […]

Posted: 16 Nov 2012 09:30 AM PST

Rod Trent posted an update in the group The Word at myITforum: Psalm 119:147 I rise before the dawning of the morning, And […]

Posted: 16 Nov 2012 08:42 AM PST

Psalm 119:147 I rise before the dawning of the morning, And cry for help; I hope in Your word.

Comments: 0

Todd Miller commented on the post, SCCM Right Click Tools September 17, 2012 update for ConfigMgr 2007/2012

Posted: 16 Nov 2012 07:48 AM PST

Figured it out. You have to run the main installer first - its the top link before you get down to the updates. The updates are separate from the main installer. They are updates to the tool - not updates to […]

Comments: 0

Todd Miller commented on the post, SCCM Right Click Tools September 17, 2012 update for ConfigMgr 2007/2012

Posted: 16 Nov 2012 07:38 AM PST

Me too. I get the error above- ed9ee86... The installer creates files at 2b64eff..., and ed9ee86 does not exist.

Comments: 0

Todd Miller became a registered member

Posted: 16 Nov 2012 07:32 AM PST

Comments: 0

Rod Trent posted an update in the group Microsoft Surface: Display shootout: Microsoft Surface RT vs. iPads vs. Android […]

Posted: 16 Nov 2012 07:17 AM PST

Cloud Infrastructure, VDI Issues Cost Businesses Millions: Endace

Posted: 16 Nov 2012 05:30 AM PST

A survey indicates businesses are rapidly adopting network-centric computing like unified communications and VDI platforms.

Owen joined the group Script Gallery

Posted: 16 Nov 2012 05:30 AM PST

Comments: 0

Owen joined the group System Center Service Manager

Posted: 16 Nov 2012 05:18 AM PST

Comments: 0

Owen joined the group Software Licensing and SAM

Posted: 16 Nov 2012 05:18 AM PST

Comments: 0

Owen joined the group System Center Operations Manager

Posted: 16 Nov 2012 05:18 AM PST

Comments: 0

Owen joined the group System Center Orchestrator/Opalis

Posted: 16 Nov 2012 05:18 AM PST

Comments: 0

Rod Trent uploaded the file: Query for Java to Configuration Manager Queries, Reports, and MOFs

Posted: 16 Nov 2012 05:06 AM PST

Use this query to locate Java inventory. You'll need to modify the versioning information in the query to find the version you are inventorying.

Comments: 0

Owen became a registered member

Posted: 16 Nov 2012 05:02 AM PST

Comments: 0

You are subscribed to email updates from SCCM by Davis
To stop receiving these emails, you may unsubscribe now.
Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610
System Center Configuration Manager - Davis Blog

No hay comentarios:

Publicar un comentario

SCCM by Davis