Solved

SMS Provider Error in Configuration Manager 2007 Setup

Posted on 2009-07-07
5
709 Views
Last Modified: 2013-11-21
<07-07-2009 10:41:02> CompileMOFFile: Failed to compile MOF D:\Program Files (x86)\Microsoft
Hi Guys

I have a 64bit 2008 member server ,a remote Windows 2003 R2 server running SQL 2005 SP2 in a Windows 2008 AD. I am trying to install Configuration manager and keep getting the same error.

I have tried setting the SPN using SetSPN and Adsiedit but all to no avail.


ERROR::
Configuration Manager\bin\i386\smsRprt.mof, error -1
<07-07-2009 10:41:02> Setup cannot compile MOF file D:\Program Files (x86)\Microsoft Configuration Manager\bin\i386\smsRprt.mof.  Do you want to continue?
<07-07-2009 10:41:02> Setup failed to install SMS Provider.  For more information about this error, see Microsoft Knowledge Base at http://microsoft.com or contact Microsoft Technical Support for further assistance.

Any help would be much appreciated.

Afternoonan
0
Comment
Question by:afternoonan
  • 2
  • 2
5 Comments
 

Author Comment

by:afternoonan
ID: 24793816
All Services on the SQL box running under the Local Service Account except Integration Service running under NetworkServices

When I reset the SPN I am now getting an error saying the Site Machine Account is not a member of the SQL Machines Local Administrators Account when in fact it is?
0
 
LVL 10

Expert Comment

by:JonLambert
ID: 24832601
Which server are you installing the ConfigMgr provider on to?

The server which you are installing the ConfigMgr provider on to must be in the local admins group of the SQL server, as well as a SysAdmin for the database

Also, check that you have Named Pipes enabled on the SQL server.
0
 
LVL 6

Expert Comment

by:anubhavsharma18
ID: 24833584
Create SPNs
http://support.microsoft.com/default.aspx?scid=kb;EN-US;829868

setspn A MSSQLSvc/[SERVER-NAME]:1433 svc_[server-name]_sqls
setspn A MSSQLSvc/[SERVER-NAME].domain.net:1433 svc_[server-name]_sqls

svc_[server-name]_sqls is SCCM SQL Service  account
[server-name] is the name of the primary site server where the relevant SQL server resides.




0
 
LVL 6

Expert Comment

by:anubhavsharma18
ID: 24833588
setspn -A MSSQLSvc/[SERVER-NAME]:1433 svc_[server-name]_sqls
setspn -A MSSQLSvc/[SERVER-NAME].domain.net:1433 svc_[server-name]_sqls

Replace !! with -
0
 
LVL 10

Accepted Solution

by:
JonLambert earned 500 total points
ID: 24833756
afternoonan has already said that he tried setting the SPN .. if you answer is not already solved, could you make sure you have not set duplicate SPNs by running the followin ldifde command (from http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/bc4c22f1-d5f5-40aa-b250-4b718ff16ec8 .. i haven't tried this myself, so please check this out for yourself first)

ldifde -f c:\ldifde.txt -t 3268 -d "dc=contoso,dc=com" -l serviceprincipalname -r (serviceprincipalname=MSSQLSvc*) -p subtree (replace contoso and com with your domain)

Please do not follow any advice given (by any of us) blindly, always try and check out what we say to do with in conjunction with your own research.  I believe that the practice of some members of this site to just post commands to run without any explanation why to run them is bad practice for this site!


0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you considered what group policies are backwards and forwards compatible? Windows Active Directory servers and clients use group policy templates to deploy sets of policies within your domain. But, there is a catch to deploying policies. The…
Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question