Error Creating Security Descriptor For Shared Objects Sql 2005
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Retired content Samples We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: SQL 2005 Agent job step calling ActiveX subsystem fails SQL Server > SQL Server Tools Question 0 Sign in to vote I’m having problems configuring an SQL 2005 agent job step, with the new Credential and proxy setup stuff. I followed the set up as per BOL and “What’s new in SQL Agent” (I think) but it’s not working. The job can be called correctly and does start and execute but the ActiveX job step fails with: “Error creating security descriptor for shared objects (reason: No mapping between account names and security IDs was done).” I tried adding user permissions to the agent account per Q283811 (Replace a Process Level Token, etc.) but it still didn’t work. It DOES work if I set up the SQL Agent Service to run under a local admin account (PSystem referenced below) instead of Local System though so it definitely seems to be a permissions issue. Since the "What's new" technet article says “If you upgrade to SQL Server 2005, the existing proxy account is created and all subsystems are assigned to this single proxy account. This enables your SQL Server Agent jobs to continue to function as they did in SQL Server 2000 after the upgrade.”, I even built a whole new system at SQL 2000 and verified that the agent job step functions fine, upgraded SQL to 2005 and it still fails with the same error. Here’s the generated script of the setup steps I’m doing: CREATE CREDENTIAL [PSystem] WITH IDENTITY = N'DOLPHIN\PSystem', SECRET = N'...' GO msdb..sp_add_proxy @proxy_name = 'PProxy', @credential_name = 'PSystem' GO CREATE USER [DOLPHIN\PUsers] FOR LOGIN [DOLPHIN\PUsers] GO EXEC msdb..sp_addrolemember N'SQLAgentUserRole', N'DOLPHIN\PUsers' GO msdb..sp_grant_login_to_proxy @login_name = 'DOLPHIN\PUsers', @proxy_name = 'PProxy' GO msdb..sp_grant_proxy_to_subsystem @proxy_name = 'PProxy', @subsystem_name = 'ActiveScripting' GO msdb..sp_grant_proxy_to_subsystem @proxy_name = 'PProxy', @subsystem_name = 'CmdExec' GO The PSystem account is a local windows admin that I need the job step to run under for network permissions, the PUsers group is a general windows use
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2005 Forums SQL Server Administration (2005) Running ActiveX script giving error Reply to Topic Printer Friendly Author Topic rubs_65 Posting Yak Master 144 Posts Posted-12/05/2007: https://social.msdn.microsoft.com/Forums/en-US/a4a7e1a9-67ff-4255-8e4f-925f0659baf0/sql-2005-agent-job-step-calling-activex-subsystem-fails?forum=sqltools 11:22:59 Hi,We are moving our maintenance jobs from SQL Server 2000 to SQL Server 2005 and getting following error when it tried to run ActiveX script at 1 of the steps:"error creating security descriptor for shared objects(reason: No mapping between account names and security IDs was done) I tried running the job as "SA" user and "Windows Admin" user but still the same http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=93735 issue, What need to be done to fix this issue?Thanks--rubs Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Server and Reporting Services (2012) Replication (2012) Availability Groups and DR (2012) Other SQL Server 2012 Topics SQL Server 2008 Forums Transact-SQL (2008) SQL Server Administration (2008) SSIS and Import/Export (2008) High Availability (2008) Replication (2008) Analysis Server and Reporting Services (2008) Other SQL Server 2008 Topics SQL Server 2005 Forums Transact-SQL (2005) SQL Server Administration (2005) .NET Inside SQL Server (2005) SSIS and Import/Export (2005) Service Broker (2005) Replication (2005) High Availability (2005) Analysis Server and Reporting Services (2005) Express Edition and Compact Edition (2005) Other SQL Server Topics (2005) SQL Server 2000 Forums SQL Server Development (2000) SQL Server Administration (2000) Import/Export (DTS) and Replication (2000) Transact-SQL (2000) Analysis Services (2000) MSDE (2000) Development Tools ASP.NET Reporting Services Development Other Development Tools Site Related Forums Site Related Discussions Article Discussion Poll Discussio
från GoogleLogga inDolda fältSök efter grupper eller meddelanden
out having to use the Deployment Wizard. The Deployment wizard is not listing all of my packages. So I 'm trying to use a job instead. Visit www.sqldts.com "Nadia"