Error while executing a sql job “The EXECUTE permission was denied on the object ‘sp_start_job’,database ‘msdb’,schema’dbo’.

SOLUTION:

1) Go to MSDB– Security –Users — UserName — User Name Properties — Assigned the ‘TargetServerRole’ in msdb

2)     Run the query

select pr.name, dp.permission_name, dp.state_desc

 from   msdb.sys.database_permissions dp

 join   msdb.sys.objects o on dp.major_id = o.object_id

 join   msdb.sys.database_principals pr

 on dp.grantee_principal_id = pr.principal_id

 where  o.name = ‘sp_start_job’

 

3)     Grant  Execute permission to concern user to SP_Start_Job and SP_Stop_Job and it resolved the issue.

Unable to install Windows Installer MSP fileExit Code Returned: 11032

SYMPTOM

Service Pack 4 for SQL Server Database Services 2005 ENU (KB2463332)’ could not be installed.

ERROR

  • ————————————————————————————————

Product                   : Database Services (MSSQLSERVER)
Product Version (Previous): 2221
Product Version (Final)   :
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
Error Number              : 11032
Error Description         : Unable to install Windows Installer MSP file. fileExit Code Returned: 11032.
————————————————————————————————

SOLUTION:

1)     Go to the location.


Continue reading “Unable to install Windows Installer MSP fileExit Code Returned: 11032”