Jump to content


LionelB

Distribution package - Permissions denied

Recommended Posts

Hello,

 

I'm using SCCM 2012 SP1 and sometimes I've got a problem when I distribute a package.

In the console, the package distribution is displayed as "In progress".

In the PkgXferMgr.log, i can find the following information.

It looks like some rights are missing ("selection permission denied") but the computer account (my Management point) is sysadmin of the database. And if i redistribute the package, sometimes It works.

Have you already met this problem ?

Do you have any ideas about that ?

 

Thank you for your help.

Completed post-actions for remote DP SERVER  $$<SMS_PACKAGE_TRANSFER_MANAGER><08-07-2013 02:38:39.521-120><thread=6828 (0x1AAC)>
~Sending completed successfully  $$<SMS_PACKAGE_TRANSFER_MANAGER><08-07-2013 02:38:39.522-120><thread=6828 (0x1AAC)>
~Deleting remote file 101BCAAA.PCK  $$<SMS_PACKAGE_TRANSFER_MANAGER><08-07-2013 02:38:39.523-120><thread=6828 (0x1AAC)>
Notifying pkgXferJobMgr~  $$<SMS_PACKAGE_TRANSFER_MANAGER><08-07-2013 02:38:39.523-120><thread=6828 (0x1AAC)>
COutbox::TakeNextToSend(pszSiteCode)  $$<SMS_PACKAGE_TRANSFER_MANAGER><08-07-2013 02:38:39.531-120><thread=6828 (0x1AAC)>
*** [42000][229][Microsoft][SQL Server Native Client 11.0][SQL Server]The SELECT permission was denied on the object 'vSMS_Program', database 'CM_AAA', schema 'dbo'.  $$<SMS_PACKAGE_TRANSFER_MANAGER><08-07-2013 02:38:39.534-120><thread=6828 (0x1AAC)>
Failed to send status to the distribution manager for pkg AAA0006A, version 0, status 3 and distribution point ["Display=\\SERVER\"]MSWNET:["SMS_SITE=AAA"]\\SERVER\~  $$<SMS_PACKAGE_TRANSFER_MANAGER><08-07-2013 02:38:39.536-120><thread=6828 (0x1AAC)>
*** SELECT SC.SiteType FROM SMSData S INNER JOIN SC_SiteDefinition SC ON SC.SiteCode = S.ThisSiteCode  $$<SMS_PACKAGE_TRANSFER_MANAGER><08-07-2013 02:38:39.540-120><thread=6828 (0x1AAC)>
*** [42000][229][Microsoft][SQL Server Native Client 11.0][SQL Server]The SELECT permission was denied on the object 'SC_SiteDefinition', database 'CM_AAA', schema 'dbo'.  $$<SMS_PACKAGE_TRANSFER_MANAGER><08-07-2013 02:38:39.540-120><thread=6828 (0x1AAC)>

Share this post


Link to post
Share on other sites


To complete the previous post, If i reboot the primary site, the distribution works fine for 10 minutes then I keep getting the following message

*** [42000][229][Microsoft][SQL Server Native Client 11.0][SQL Server]The EXECUTE permission was denied on the object 'fnGetRelatedContentID', database 'CM_AAA', schema 'dbo'.

and with the SQL trace I get the message

exec sp_InsStatusMessageInsStr 3,72057594038598327,0,N'229',72057594038598327,1,N'14',72057594038598327,2,N'[42000][229][Microsoft][SQL Server Native Client 11.0][SQL Server]The EXECUTE permission was denied on the object ''fnGetRelatedContentID'', database ''XXXXX'', schema ''dbo''.'

Do you have any ideas ?

Thank you.

Share this post


Link to post
Share on other sites

Did you ever find the cause of this issue? I've started seeing the same behaviour; content is sent but upon completion the status isn't updated. The workaround is restarting the SMS_EXECUTIVE on the primary site or redistributing the package.

Share this post


Link to post
Share on other sites

Having a similar issue myself:

 

Microsoft SQL Server reported SQL message 229, severity 14: [42000][229][Microsoft]
[sql Server]The EXECUTE permission was denied on the object 'fnGetRelatedContentID', database 'CM_XYZ', schema 'dbo'.
Microsoft SQL Server reported SQL message 229, severity 14: [42000][229][Microsoft][sql Server Native Client 11.0][sql Server]The SELECT permission was denied on the object 'SC_SiteDefinition', database 'CM_XYZ', schema 'dbo'.

 

 

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...

×
×
  • Create New...