Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SMS Provider Error in Configuration Manager 2007 Setup

Posted on 2009-07-07
5
710 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

After having deployed hundreds of thousands of Terminal Services seats worldwide, I still see all the time people asking me that same old question: "If TS/RDS is that reliable why are you telling me I should reboot it that often? My DC/SQL/Exchange/…
The question has been asked on multiple occasions as to how best to do printing in a remote desktop or terminal services environment.   It seems that this particular question has plagued several people and most especially as Terminal Services, as…
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…

808 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