LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Highly Rated Users

Forum
No Posts Rated

Top 50
Given
Received

Links

Wiki
Blog

Forum Statistics

Users
Members:
1880
Members Online:
1
Guests Online:
102

Total Post History
Posts:
81452
Topics:
18717

7-Day Post History
New Posts:
1
New Topics:
1
Active Topics:
1

Our newest member
kwanail87

Other

FAQ
All times are UTC [ DST ]

weird package stuff

Please wait...

weird package stuff

Postby Thirster42 on Wed Jun 09, 2010 10:26 pm

So, i don't remember changing any security permissions on prod, but apparently some of my dtsx packages are broke. The error they're returning is: "non-sysadmins have been denied permission to run DTS execution job steps without a proxy account. the step failed."

anyone know what could cause this change in behaviour?
Ask three DBAs a question, and you’ll get four different answers.

-Brent Ozar
User avatar
Thirster42
Guru
Guru
LTD Silver - Rating: 517LTD Silver - Rating: 517LTD Silver - Rating: 517LTD Silver - Rating: 517LTD Silver - Rating: 517
LTD Silver - Rating: 517LTD Silver - Rating: 517LTD Silver - Rating: 517
 
Posts: 4646
Joined: Tue Nov 11, 2008 5:49 pm
Location: Jefferson City, Mo
Unrated

Re: weird package stuff

Postby onpnt on Thu Jun 10, 2010 1:02 am

Did someone touch teh account that runs SQL Server Agent in AD? If you open anything that once referenced the account and see a GUIID then it was deleted. it would not affect the SQL Server until something was accessed outside of itself or restarted
Tarwn: Yeah yeah, all you do is SELECT * all day long and say "no" to people...Life of a DBA
User avatar
onpnt
LTD Admin
LTD Admin
LTD Silver - Rating: 623LTD Silver - Rating: 623LTD Silver - Rating: 623LTD Silver - Rating: 623LTD Silver - Rating: 623
LTD Silver - Rating: 623LTD Silver - Rating: 623LTD Silver - Rating: 623LTD Silver - Rating: 623
 
Posts: 1608
Joined: Tue Oct 09, 2007 5:23 pm
Location: Kenosha, WI
Unrated

Re: weird package stuff

Postby Thirster42 on Thu Jun 10, 2010 3:00 pm

well, the SQL Server Agent is set up to log on as LocalSystem.
Ask three DBAs a question, and you’ll get four different answers.

-Brent Ozar
User avatar
Thirster42
Guru
Guru
LTD Silver - Rating: 517LTD Silver - Rating: 517LTD Silver - Rating: 517LTD Silver - Rating: 517LTD Silver - Rating: 517
LTD Silver - Rating: 517LTD Silver - Rating: 517LTD Silver - Rating: 517
 
Posts: 4646
Joined: Tue Nov 11, 2008 5:49 pm
Location: Jefferson City, Mo
Unrated