dbTalk Databases Forums  

dts jobs failed

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss dts jobs failed in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sajith
 
Posts: n/a

Default dts jobs failed - 10-04-2005 , 06:28 PM






Hi,

My DTS jobs failed first of this month(Oct 1) due to the following error....

"Step Error Source: DSO Step Error Description:Unable to connect to the
registry on the server (domain name), or you are not a member of the OLAP
Administrators group on this server. Step Error code: 80040031.Step Error
Help File: Step Error Help Conte
"

When I checked the analysis server node, it was down(I was not able to
connect) and i was getting almost the above message. I have checked services
for analysis manager and found surprisingly it was still active. Manually I
have stopped and restarted the service. After this I was able to connect the
server and I was able to run the dts packages.

Analysis server service pack is sp3.

analysis manager is installed in D drive. Tempdirectory1 and
TempDirectory2(Registry) also pointing to D drive... d drive has got 2.5 GB
free space

But C:\ has only 300 Mb free space. The above error is coming because of
this.???? Is it something to do with virtual memory settings? How to find out.

All the DTS jobs have admin access to run. We never had a problem in
executing... suddenly this happened....

Any help in this regard will be very much helpful. Thanks in advance....

Thanks and regards
Sajith


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.